DBA Team Structure – Thoughts From Real Life
I once talked about the DBA team building about 3 years ago, now when I look back, I still believe...
2011-11-20
3,327 reads
Blog Posts
DBA in Space: Behind the Scenes—Question 1
This is a continuation of my DBA in Space journal.
In the opening of the first episode of DBA in Space,...
2011-11-18
628 reads
Managing By Walking Around
For a long time a core piece of my ‘style’ has been to wander the halls a couple times a...
2011-11-18
603 reads
Reference Dimensions
A reference dimension occurs when the key column for the dimension is joined indirectly to the fact table through a...
2011-11-18
1,458 reads
SQL Server – When will my backup finish?
The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are...
2011-11-18
3,472 reads
SQL Server ® 2012 Release Candidate (RC0)
Finally it is here, the SQL Server 2012 RC0 is ready for download, click this link and you’ll be downloading...
2011-11-18
751 reads
SSWUG SSIS Expo Slides and Scripts
You can find the slides and scripts from today’s sesson at the SSWUG SSIS Expo, the materials can be downloaded...
2011-11-18
538 reads
Thank you
I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the...
2011-11-18
1,475 reads
Thank You SQL Saturday 99 Sponsors!
Last Friday, Minnesota had it’s second SQL Saturday event, on a Friday. Hopefully, those that were able to attend had...
2011-11-18
569 reads
What's new for SQL Server 2012 courses from Microsoft
I tuned into the Third Thursday sessions for November and wanted to try boiling down the talks to what I...
2011-11-18
2,820 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
The Uses, Benefits, and Safety Profile of Modvigil 200 mg
I would like to discuss Modvigil 200 mg with you. Honestly, I can't say...
Check sequential order of status of items
There is a table tblItems with below structure ( i cannot change the below...
Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers