T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces...
2013-01-15
1,002 reads
SQL Server – Enabling backup CHECKSUM with Trace Flag 3023
You can use WITH CHECKSUM option to perform checksum when backup is created. When used this verifies each page for...
2013-01-15
2,363 reads
Ragged Flat File Processing in SSIS
Frequently I am asked how to properly use SQL Server Integration Services to handle ragged flat files, an example of...
2013-01-15
2,192 reads
Day 13 of 31 Days of Disaster Recovery: Standard Backup Scripts
31 Days of Disaster Recovery
Today’s post took longer to prepare than I had anticipated which is why day 13...
2013-01-15
1,459 reads
The server principal “xxxx” is not able to access the database “msdb” under the current security context.
Problem :
Yesterday Night, One of my team member called & report that some users are getting below error no. 1 while...
2013-01-15
34,383 reads
Full-Text Search – Word Breakers and Stemmers
There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to...
2013-01-14
4,512 reads
Find the (available) amount of memory available to SQL Server (instance / machine)
From time to time, I see the following question posted on various SQL forums asking how we can determine the...
2013-01-14
4,389 reads
New Year Aspirations
Every year millions of people around the world decide to make new years resolutions. In these resolutions they promise themselves...
2013-01-14
671 reads
SQL Server Performance Tuning with Free Tools!
The following is a recording of my Performance Tuning for Pirates session recorded by UserGroup.TV at SQL Saturday 125 in...
2013-01-14
937 reads
Last Weeks Top 10 “Reading” Links #15
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-14
583 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