Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I'm running
on January 29 (Vienna/Austria) and January...
2012-12-10
2,453 reads
December Checklist and Updates
It’s a bit past the first Monday in December, but better a week late than no checklist and update post...
2012-12-10
905 reads
Great Tools for Formatting T-SQL
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-10
1,217 reads
Last Weeks Top 10 “Reading” Links #10
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-10
767 reads
SQL Server Books–Query Tuning
Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization...
2012-12-10
1,054 reads
Partitioning Table in SQL Server:
Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....
2012-12-10
1,335 reads
Is Self-service BI Threatening IT Professionals’ Livelihoods?
(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is...
2012-12-09
833 reads
SQL Server Consulting Blog–Sunday Stats
I’m going to continue with my series of posts on analysing how well my SQL Server Consulting blog has done...
2012-12-09
807 reads
SQL Saturday #173 Washington DC wrap up
Today I spoke at the Washington DC SQL Saturday #173. I first spent some time in the SQL Server Performance...
2012-12-09
737 reads
SSIS: Character Replacement Using the Script Component
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...
2012-12-08
1,762 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