Latest Blog Posts
By Steve Bolton
…………This is the last of six articles I’ve segregated in this middle of my mistutorial series on identifying outlying values with SQL Server, because they turned out to be difficult to apply to the typical use cases DBAs encounter. After this detour we’ll get back on… Read more
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
- Building (for FREE) a Virtual Server for SQL Demos
- Cheating DBCC To Fix Index Corruption
- Do You Need…
You have been stressing over the big project you have to get done.
You get in early Monday morning, pour yourself a mug of coffee and stumble to your desk.
You start up your system,… Read more
March 4 – Charleston PASS, Charleston, SC
What Admins Absolutely Must Know About SQL Server Security
There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice. What do you listen to? What do you focus on? In this… Read more
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different things to different people, I’ll explain what I see as the most common definition. First let me mention that an ODS is not a data warehouse or data mart. A… Read more
One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What’dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody who writes SQL code… Read more
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task. Monitoring is a strategy, and a good DBA should have a well-defined plan for carrying out this strategy. But I’m not here to talk about monitoring as a whole. I… Read more
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered:
- Tables and Schemas in the data warehouse
- Dimensions and Slowly Changing Dimensions
- Fact tables and measures
You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support for your development teams as you possibly can, that you have to have testing in place to ensure protection of the production environment, that you need to speed your processes.… Read more
I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database. In this piece, I’m picking up from the last one where I had a loop to load all XML documents in a folder based on a pattern.
This time I… Read more
The SQL Sentry forum for SQL Statement Tuning
Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com?
You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol’ SQL Server Management Studio to… Read more
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting.
— 7/22/2014 – Changed strings to unicode
— 10/19/2014 – Add @UserLikeSearch and @IncludeMSShipped parameters.
That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered a curious issue with a query. The query itself wasn’t exactly rocket science: it read data from a few tables and calculated the start and the end dates of… Read more
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to share how to check encrypted password ?
Means once you stored your encrypted password in database now next step is to compare that particular password with your input password… Read more
Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect.
The first approach toward security to have a strong username & password and the next step is to have password in encrypted form.
Now this article will help… Read more
Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop, Cloud and MPP) for Pragmatic Works today. The abstract for my session is below and the recording will be available here tomorrow. I hope you enjoyed it!
Here is the… Read more