So then, what’s the definition of an object……..?
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
568 reads
Chris's SQL Blog
Powershell and Dynamic SSIS (or any for that matter) Config files
As I imagine that the majority of people who are reading this will have some level of SSIS knowledge, I’ll...
2011-12-05
1,173 reads
Powershell to Script out SQL Server Objects using a CMS list
I’ve recently decided I’ve got to get with the times and started dabbling with Powershell. Up until now i’ve not...
2011-09-19
1,974 reads
Being an Exceptional DBA Award 2011 Finalist
On Wednesday 13th July at 16:06 (GMT) I got what could only be described as the biggest shock of my...
2011-07-25
828 reads
NetApp Dynamic Backup Script
For those of you who’ve worked with NetApp and SnapManager for SQL Server, you will know can generate a scheduled...
2011-06-09
1,169 reads
SnapManager Epic Fail – oh dear!
An ex colleague and good friend of mine has recently been having trouble with Snapmanager for SQL, anyone had similar...
2011-04-07
671 reads
Why I don’t like NULLs and Nullable Columns
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...
2011-03-25
730 reads
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
912 reads
Poll: – Index Rebuild / Defrag, what page count filter do you set?
After reviewing a number of clients overnight index defrag / rebuild scripts over the years, I’m intrigued to know how many...
2011-03-11
726 reads
Blogs
Daily Coping 25 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Database DevOps Deployment to Azure–Webinar
By Steve Jones
You can register now, but on Dec 3, I have a webinar with Microsoft...
[PowerShell Newbie] Using Start-Transcript
By gbargsley
This week we are going to launch a blog series geared towards folks that...
Forums
running openquery with local database and server credentials
Hi guys, I have an application that can only call views: The data it...
SQL Server Collations
So can anybody tell me if they have experienced issues when running a SQL...
Points of consedering during "Transaction Processing"
Hello Everyone, Here I need suggestions while I am trying to do some transaction...
Ask SSC