First Day of Summit
My first day in Seattle has ended. My flight arrived around 12:30 and I was in good company with John...
2011-10-11
743 reads
Analysis Services 2008 R2 Performance Guide
You must read this if you work with SSAS:
Analysis Services 2008 R2 Performance Guide
Infact, I would recommend re-reading it a number...
2011-10-11
1,036 reads
Dude, Where is my memory?
We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM....
2011-10-11
689 reads
PASS Summit Q&A RoundTable Discussion w/MVPs and Presenters...
Hello, SQL Community and PASS Summit attendees!
This is an exciting week for all of us! It's wheels down for so many in...
2011-10-11
753 reads
Remove All Foreign Keys
To clear test data from a database we could use truncate commands but sometimes we need to get rid of...
2011-10-11
40,813 reads
PASS Summit 2011 Day -2 (Monday), part 2
Today was a good day. I posted about the first part of today earlier, and we left off there with...
2011-10-11
519 reads
Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.
Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don’t have...
2011-10-11
1,256 reads
Using Custom Code Functions in Reporting Services Reports
Reporting Services is one of those tools that just keeps on giving. I’ve been using SSRS since the early beta...
2011-10-11
2,862 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,308 reads
Hardware 301: Diving Deeper into Database Hardware
On Wednesday, October 12, at 10:15AM, I am going to get the pleasure of presenting my Hardware 301: Diving Deeper...
2011-10-11
1,104 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