SQL Server Data Tools (SSDT) – November 2012 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: new version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0
VS 2012: new...
2012-12-06
2,991 reads
Lost in Translation – Deprecated System Tables – syslockinfo
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-12-06
1,550 reads
Microsoft Surface: Top Apps… So Far
After living with the Surface for a month and trying hard to make it work as a tool for production,...
2012-12-06
1,761 reads
Free SQL Server Learning Resources - Updated
Here is updated list of *free* invaluable SQL Server learning resources.
Unknown is an ocean.
You think I missed some important freely...
2012-12-06
3,325 reads
My new favourite traceflag
As we are all aware, there are a number of traceflags. Some documented, some semi-documented and some completely undocumented. Here...
2012-12-06
1,004 reads
Blog Redesigned
Since it’s been a while since I made any real changes to the design of this blog, it was time...
2012-12-05
738 reads
12 Steps to Workload Tuning – Winter 2012 Performance Palooza!
[UPDATE] Video recording from PASS Virtual Performance Chapter’s Winter 2012 Performance Palooza can be found here.
I am a huge fan...
2012-12-05
881 reads
Experimenting with Social Media
After multiple talks with Jason Strate (blog|twitter) and Denny Cherry (blog|twitter) about how they are working on automating more of...
2012-12-05
1,134 reads
how to get ahead
Many people have ideas as to how to do well in life. Of course, many people do not even agree...
2012-12-05
1,643 reads
Next Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Dec'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...
2012-12-05
1,601 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers