Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. But where to look? As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white … [Read more...]
New White Paper: SQL Server Extended Events and Notifications
Filed Under: Administration, Challenges, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, SQLMag, Tips & Tricks Tagged With: Best Practices, DBA, Internals, Monitoring, SQL Server 2008 R2
ITPro, Re-architect Your Life
Have you ever found yourself wanting to make a major shift - in skills, in roles, in relationships? One of my good friends, Jimmy May (Blog | Twitter), accomplished a set of major career and lifestyle revisions including relocating to Redmond, taking on a huge new level of job responsibility as part of the Microsoft SQL Customer Advisory Team, and achieving the noted accreditation of Microsoft Certified Master. Jimmy and I were chatting about undertaking major life changes like these and, as is often the case, his thoughts were too good not to share. Be sure to explore these excellent … [Read more...]
Filed Under: Conferences, On-Line Resources, Presentations, Professional Development, SQLMag, SQLServerPedia Syndication Tagged With: Career, Goals, Leadership, Management, Plays Well With Others, Professional Development
Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database
Here's an evergreen question. It's a question that never completely goes away. But lately, I've been getting it a few times per week. So I thought it's time to readdress the question, which usually takes some form of the following: I can't really do effective development on my little dev laptop because our production SQL Server database is 15 gazillionbytes, way too big for my workstation. What's a uber-nerd to do? Well, maybe they didn't use the word "uber-nerd". But you get my drift, right? The production database is really, really big - unmanageably big for keeping a local copy. … [Read more...]
Filed Under: Challenges, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Tool Time, Transact-SQL Programming Tagged With: Best Practices, DBA, Developer, Performance, Transact-SQL Programming
Have You Heard About the Microsoft TechNet Wiki?
Here's another one to add to your list of browser bookmarks! The TechNet Wiki covers Microsoft technologies from writers throughout the community for use by the community. As with all wikis, this grassroots effort needs your help. Microsoft is encouraging everyone to contribute the effort - all you have to do is join. So start a whole new article, add your knowledge or draw from your experience to improve an existing article. You can start small or large... Join in at http://social.technet.microsoft.com/wiki/ or simply use the wiki as a new resource to answer your tough technology … [Read more...]
Filed Under: Cool Technologies, On-Line Resources, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: TechNet, Wiki
Must-Have Resources – SQL Server Backup & Recovery
One of the things that drives me crazy as I'm getting older is that my brain is losing the capacity to differentiate version numbers. As I speak travel around speaking with customers and at conferences, I find my self saying things like "I can't recall if this problem was fixed in SQL Server 2000 or 2005. But you don't have to worry about that any more." Or things like "That feature was added in SQL Server 2008 R2, eh, or was that version 6.5. DOH!" followed by a loud slapping sound as I whap my palm into my forehead. The Internet doesn't forget either. Recommendations that were once … [Read more...]
Filed Under: Administration, Challenges, Databases, On-Line Resources, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Backup & Recovery, DBA, Quest Software, SQL Server 2008 R2, Video
Everybody Needs a Test Harness
When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified stored procedures that I was so proud of might not actually be faster than the first generation of procedures because I hadn't checked to ensure that I was testing cached programs against uncached programs (and, by extension, the data used by those … [Read more...]
Troubleshooting Repeated Login Failures on SQL Server
I’d recently experienced a situation where I was getting repeated login failures to a SQL Server where I knew that I had the correct user name and password. Each time, I’d get error 18456 in response. "Login failed for user '<user_name>'. (Microsoft SQL Server, Error: 18456)". The challenge when troubleshooting this error message is that you may have a problem with SQL Server or you may have a problem with Active Directory or Kerberos, if you’re using one of those authentication technologies. A False Trail When times are good, and you’re able to make a connection, you … [Read more...]
Filed Under: Administration, Challenges, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks Tagged With: MVP, SQL Server 2008 R2, Troubleshooting
Microsoft Document Watch for Operational Excellence
Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence. I read everything I could on the topic. I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins. (Perhaps that list of favorites might, in and of itself, make a good blog post). Fast-forward a decade and I'm still mightily interested in operational excellence for IT organizations. It's just that so much good material is available for free on the … [Read more...]
Filed Under: Administration, Architecture, Compliance, Cool Technologies, Hardware, On-Line Resources, Security, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies, TCD blog post, Tips & Tricks, Virtualization Tagged With: Architecture, Best Practices, Compliance, DBA, Enterprise Architecture, Management, Operations, Performance, Security, SQL Server 2008 R2, Tools, Troubleshooting
ETL Demo with Data From Data.Gov
A little over a month ago, I wrote an article (Is There Such a Thing as Easy ETL) about expressor software and their desktop ETL application, expressor Studio. I wrote about how it seemed much easier than the native ETL tools in SQL Server when I was reading up on the tool, but that the "proof would be in the pudding" so to speak when I actually tried it out loading some free (and incredibly useful) data from the US federal data clearinghouse, Data.Gov. If you'd rather not read my entire previous article - quick recap, expressor Studio uses “semantic types” to manage and abstract mappings … [Read more...]
Filed Under: Administration, Cool Technologies, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks Tagged With: Data Cleansing, Data Quality, DBA, ETL, Master Data Management, SQL Server 2008 R2
Blogger, Have You Heard of Microsoft Broadcaster?
Introducing the Microsoft Broadcaster: A self-service technical content repository that provides you with rich content for your blogs/sites. On behalf of Microsoft, I would like to invite you to dive into Microsoft Broadcaster. It's a site that unleashes a torrent of free technical content like Videos, Webcasts, Whitepapers, eLearning, and more, which you can use in your blogs or user group site to drive deeper engagement with your audience and community. Key Features of Microsoft Broadcaster include: Download and embed content on your sites without sending traffic away … [Read more...]
Filed Under: Cool Technologies, On-Line Resources, Web2.0 Tagged With: Career, Tools & Scripts, Video, Writing
