SQL Server – Error Msg 102, Level 15, State 1, Line x when using sys.dm_db_index_physical_stats
You run into this error when using sys.dm_db_index_physical_stats DMV on a database which is running under SQL Server 2000 (80)...
2011-11-14
1,873 reads
A Plug for IT Pro Camps
Here is something else that started in Florida (doesn’t everything?), a series of events along the lines of Code Camp...
2011-11-14
585 reads
Lists of Words You May Not Know
The Merriam-Webster site has an interesting list of Top 10 Lists, ranging from commonly confused words to things you didn’t...
2011-11-14
647 reads
Culture Shock
The work I’m doing right now has nothing to do with SQL Server, and while it deals with technology, it’s...
2011-11-14
696 reads
Some SQL Server Security Housekeeping
Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using...
2011-11-14
1,668 reads
SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a red-eye trip from Salt Lake to New York. The...
2011-11-14
12 reads
SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a...
2011-11-14
547 reads
SQLInspire - Follow-up & Post Event Notes....
This blog entry is a short post-event follow-up for all our followers and attendees at the event! I will have...
2011-11-14
1,018 reads
The Industry Problem according to @Way0utWest
Steve Jones (blog/@way0utwest) from SQLServerCentral posted his daily editorial today titled "The Industry Problem" in which he describes an article he...
2011-11-14
1,025 reads
SQL Server 2012 licensing
Microsoft has recently released the licensing overview for SQL Server 2012. A few things has changes from SQL Server 2008,...
2011-11-14
953 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