Latest Blog Posts
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
Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)
Want to learn more about SQL Server? Now’s a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively.
I hope you’ll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the… Read more
I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering topics on business intelligence and data. I have worked with Josh for years at a Magenic and now Pragmatic Works. I look forward to seeing what he will be writing… Read more
There are many different ways to accomplish this tasks.
The below examples uses undocumented sp’s to loop through all the user defined database to search the SP’s using given string
CREATE TABLE #ProcSearch (databaseName VARCHAR(100),ROUTINE_CATALOG varchar(50),ProcName VARCHAR(128),RoutineType varchar(100),CreateDate date) DECLARE @command varchar(1000) SELECT @command = 'IF ''?''…
Check out this DevOps Reactions animated GIF and caption.
It’s funny on multiple levels, but it also makes me both mad and disappointed.
I get mad because it’s 2015. Surely by now most of us, especially those who have worked in the enterprise with development teams, know that the old… Read more
UPDATED: Don't just take my word. Read the feedback from others.
- SQL Cruise Caribbean 2015: More Than A Cruise With Classes. Much More. - Jes Borland
- SQL Cruise Caribbean 2015 Wrap Up - David Klee
- Caribbean: The Final Sql Frontier - Mickey Stuewe
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can run the undocumented sp_who2 stored procedure but that will only give you the session that is being blocked. You could download the excellent sp_whoisactive, written by Adam Machanic, which… Read more
Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun.
On Wednesday, March 4, at 4:45PM, I’ll deliver my session “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.
The session talks about a big… Read more
So you’ve come up with a great idea for a session and now you have to translate that idea into a thorough abstract that helps both organizers and attendees understand what to expect from your session. This can make the difference between you getting a session at your favorite conference… Read more
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which SQL Server provides.
By using this stored procedure we can easily determine all the dependencies of particular table.
The stored procedure is sp_msdependencies
We can use this stored procedure… Read more
I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were causing a few extra items to appear in a SQL Compare demo and weren’t needed. The individual that had set up the VM I was using wasn’t sure what to… Read more
Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info about SQL Server performance issues authored by the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013:
It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to buy or not to buy a book, but don’t contain a lot of the “why” or “why not” to do so. But, every once in a while a book comes… 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
Seats are limited – act fast!
This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA on Wednesday, February 25th and Friday, February 27th. Join me to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI.
In the first part of… Read more
Feb 16, 2015
A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were not just putting NOLOCK on almost every query but they had SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED at the beginning of the stored procedures. HAL’s done his job… Read more
T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same result set. EXCEPT returns the records from the query on the left that are not found in the right query. INTERSECT returns the distinct rows that are in… Read more
It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command.
When someone wants to determine detail of a function or stored procedure he/she can use this useful command.
The syntax is very simple. Just write… Read more
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before I announce what they are I wanted to first say thank you to everyone who submitted it certainly made making a choice very difficult.