July 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist. Even though it hasn’t been...
2014-07-21
722 reads
Blog Posts
Last Weeks Top “Reading” Links #93
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-07-21
981 reads
Null Values in SQL Server
Walk & Talk #001 – Unknown or Null Values
Ride with us in this video as we head to Richmond, Virginia to present...
2014-07-21
612 reads
PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline
Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all...
2014-07-21
459 reads
Powershell Tips–Showwindow
Looking for help is a pain in Powershell. I type something like
help get-process
execute this and I’m scrolling up and down....
2014-07-21
1,159 reads
Rename SharePoint Central Administration Database
SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that...
2014-07-21
1,445 reads
Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step...
2014-07-21
4 reads
Tampa Code Camp Revivial
If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you...
2014-07-21
746 reads
Victims of Success
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how...
2014-07-21
670 reads
Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)
Continuation from the previous 33 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Segment Elimination for Deleted Row Groups
After some very interesting and inspiring conversations...
2014-07-20
552 reads
Blogs
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...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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