Refresh QA Database with Manual Scripts
Couple of week back Megha Sharma send me an email with a document attached, this document is all about how...
2011-10-27
711 reads
Presenting at SQL Saturday #87
On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to...
2011-10-27
705 reads
SQL University: SQL Agent Jobs That Run at SQL Agent Start
Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some...
2011-10-27
2,963 reads
Buckets for Disaster Recovery
Disaster recovery can be a huge project at any company. Considering the ways in which you build a plan that...
2011-10-26
1,355 reads
Dimensional Modeling Financial Data in SSAS
Part 1 – Parent Child Hierarchies and Pseudo GL Accounts
This post is born out of some real life lessons that I...
2011-10-26
5,538 reads
Watch those VARCHAR(MAX) columns, and ONLINE index rebuilds
G’day,
I’ve noted a few instances lately of cases where VARCHAR(MAX) columns have been used unnecessarily, when a small value (for a...
2011-10-26
14,458 reads
Miss TechEd Australia 2011? No problem, all videos are online
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
860 reads
Applied SQL: Demonstrate Simple Backup and Restore
Let’s apply a little backup and restore knowledge, eh wot?
I introduce this whole concept in Applied SQL: You Have Homework....
2011-10-26
808 reads
A Bit of a SQL Saturday 99 Update…
I’ve been a bit busy while planning this year’s SQL Saturday in Minnesota. Unfortunately, that hasn’t led to a lot...
2011-10-26
757 reads
SSAS – Deployment Wizard
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your...
2011-10-26
7,405 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