Latest Blog Posts
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns listed in the output
For more information about the columns refer the below the…
This post has been sitting in the draft folder for way too long, March of last year to be precise. So although this is no longer new information, it has not been talked about all that much. I’m talking about the new feature in SQL Server 2012 that allows you… Read more
SQLSaturday returns to Houston this year, this time at San Jacinto College on May 10, 2014. That’s the Saturday just before Teched, so you can make a super week of it. I haven’t decided yet if I’ll attend, it turns out SQLSaturday Jacksonville is on the same day. Jacksonville… Read more
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box, one of the tables looked like this:
For readability purposes, a 1000 separator is added to the numeric value. However, the comma was used, as is common in the… Read more
No, I don’t mean the use of sp_updatestats is not smart. It’s a fine, quick mechanism for getting statistics updated in your system. But the procedure itself is not smart. I keep seeing stuff like “sp_updatestats knows which statistics need to be updated” and similar statements.
Wanna… Read more
I saw this sign recently, which at first glance is unremarkable, but I couldn’t help be amused at the inclusion of “vessels”. I’m in Florida so I suppose someone parking their boat on a trailer in the parking lot isn’t impossible, but somehow that doesn’t seem big enough… Read more
It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has asked us to “Argue against a popular opinion”. Now I do have a concern about this subject. I am frequently sarcastic and frequently people don’t realize… Read more
I made a couple of changes in the order of the queries this month and made some other small improvements to a few queries. Rather than having a separate blog post for each version, I’ll just put the links for all five major versions in this single post. There are…
Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the modify date is updated. It can be queried as follows:
USE [SqlAndMe] GO SELECT [TableName] = name, create_date, modify_date FROM sys.tables WHERE name = 'TransactionHistoryArchive' GO
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It does a lot of good work, but it’s not what I’d call great (and wow, is it better than v1 and v2!), but it does offset that weakness by allowing… Read more
About a year ago, fellow blogger Thomas LaRock recommended the book The Phoenix Project, claiming that “every business leader and IT professional should read this book”. Since I’m an IT professional (no jokes, please), and I’m supposed to be leading a team, that means me. He also uses the… Read more
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of this: 3/1/2011
You want to see this: 03/01/2011
There is an easy way to do this using the Right() function and adding a string zero to the front of a…
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that comes with SSIS to build a Package that sourced data from a flat file and loaded it into a Table in a SQL Server Database.
I also mentioned another… Read more
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th normal form, but there needs to be an understanding of some design practices. The keys are:
- No Duplicate data in columns in one table
- Relationships built as…
The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL Server Master program, which caused a large uproar in the community. Enough has been said on this subject…
Next, since the SQL Server platform is going through more frequent… Read more
When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository. That allows you to see patterns and hopefully track incidents across systems. As a result, if you want to track actions in VMware’s vCenter and you’ve got the database hosted… Read more