PASS 2011 Recap
Last week was the PASS Summit in Seattle (again, but only for 1 more year) and I was up there...
2011-10-18
1,517 reads
SQLInspireNYC Event - We're giving away SQL MVP Deep Dives Vol.2
Now the PASS has well passed, folks are setting their sites on our upcoming NYC SQLPeople event called SQLInspireNYC .
SQLPeople...
2011-10-18
941 reads
Understanding Kerberos, Part II
The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...
2011-10-18
4,074 reads
SQL Server Collation
Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.
--To find...
2011-10-18
540 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,486 reads
AWE has removed from SQL server 2012
AdvertisementsAWE has removed from SQL server 2012
AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit...
2011-10-18
1,049 reads
SQL Server 2008 R2 RTM CU10
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 10. This is Build 10.50.1807.0, and it has 13 listed...
2011-10-18
837 reads
SQL Server 2008 R2 SP1 CU3
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 3. This is Build 10.50.2789.0, and it has 22 listed...
2011-10-18
1,169 reads
Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,259 reads
The Demise of Jar Jar
Today we have a guest post from Steve Jones as Brad is on vacation.
Today we have the third question from...
2011-10-17
530 reads
Blogs
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...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
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