My Schedule for The Remainder of 2011
Just a few notes about things I’m doing over the next few months:
July 30 – Attending SQLSaturday Birmingham. I went to...
2011-07-25
576 reads
Blog Posts
OMG I’m an MVP!
I can’t believe it, but I can finally say that I’m now officially a Microsoft SQL Server MVP! Last week...
2011-07-25
781 reads
Setting role security in SSAS for a role-playing dimension
Here is a common got-ya. You are modifying the cube dimension security for a role-playing dimension. You make the changes and...
2011-07-25
2,027 reads
Speaking Schedule! I’m here (and there, and there…) to help
Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable...
2011-07-25
569 reads
Using SMO Transfer Class to Script Database Objects
I’ve spent some time trying to get the SMO Transfer class to bend to my will. I want to script...
2011-07-25
4,931 reads
Building or Buying a High Performance, Low Cost Desktop Machine for SQL Server Development and Testing
There was a lengthy discussion on Twitter this morning, where one of my friends, Grant Fritchey (Twitter) was asking the...
2011-07-24
1,732 reads
South Florida IT Camp Presentation
Presentation and scripts from my Storing Powershell Output session at the South Florida 2011 IT Camp:
2011-07-24
612 reads
Bad Admins: Stealing the SQL Server Service Account
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-22
1,369 reads
Conditionally summing up values in a dataset in SSRS
Recently I had situation wherein I had to conditionally sum up a data set and display the value in a...
2011-07-22
17,847 reads
Dynamically generate current Year, Month or Date member with MDX
MDX can be extended with Visual Basic functions like the FORMAT() and NOW() functions to dynamically generate the current year, month or...
2011-07-22
2,537 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers