SQLBits XI - My second most eagerly awaited event of 2013...
I bet you are half wondering what is the first? Well that would be the birth of my second child...
2013-01-17
797 reads
Does the SQL Server Database Filename Matter?
Do you know the basics of how to create a database? Hopefully you do and can do so without the...
2013-01-17
2,810 reads
Leverage Policy Based Management for regular Page Verify =Checksum compliance monitoring
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new...
2013-01-17
1,050 reads
SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries
After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to...
2013-01-17
1,243 reads
New Years Aspirations – James Rowland-Jones – PASS
Thanks for agreeing to do this James; I know as you run your own company your time is billable!
Before we...
2013-01-17
1,538 reads
STATS_DATE() Doesn’t Indicate The Validity of Statistics
From time to time, you might have caught yourself in a conversation similar to the following:
Fred: Hey folks, we have...
2013-01-17
1,278 reads
The right terminology for the right audience
For those who has the privilege of being in the technology consulting industry for some time and started out in...
2013-01-17
400 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database. You can read that story here. This...
2013-01-17
10 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of...
2013-01-17
1,244 reads
Cash Over Credit
What does cash over credit have to deal with security? An awful lot, as it turns out.
Personal Story: Mere days...
2013-01-17
1,224 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