SQL Server 2012 AlwaysOn Presentation Given at Vermont PASS SQL Server User Group Last Week
This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...
2013-12-16
1,332 reads
HuggyBear
SQL Server Installation Folder Setup Log and Command Line Install Information
The other morning I was commenting during our regular meetings amongst fellow DBAs on where to read up on installation...
2013-12-11
4,124 reads
Leveraging LinkedIn to Contribute to the DBA Community & Attract Opportunities with Internationally-Oriented Organisations
LinkedIn has matured over the past decade and I can
sincerely say it is well worth the time setting up your...
2013-10-09
1,249 reads
How to Avoid the 'Abuse' of SysAdmin by Applying User Defined Roles in SQL 2012 (and keep Exec.s and Auditors Happy)
This will not be a typical post, just a dive right away into Data Access Language Code, which provides a...
2013-09-10
3,692 reads
Managing Multiple Servers Thanks to Registered Servers & the Benefits
Since I changed organisations in January this year, I asked one of my colleagues to export his SQL Server Management...
2013-08-01
1,748 reads
Managed Service Accounts - The Saviour for the Domain-based SQL Server Service Account?
For those Database Administrators seeking to lock-down security related to a Service Account(s), there is an option starting with Windows...
2013-06-21
2,209 reads
Managing Critical Server Lists with Remote Desktop Connection Manager
Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which...
2013-02-25
2,419 reads
Executive Visibility for DBAs: Use SQL 2008 Row+Page Compression, or SQL 2005 (SP2+) vardecimal Conversion, to Reduce Space ($/GB SAN) & Logical Reads
One of the great features available since SQL 2008 is Row and/or Page Compression. However, even for those of you on SQL...
2013-02-08
2,756 reads
SQL Server 2012 with SP1 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery
Since the last guide was quite popular (over 4k distinct views for SQL Server 2008 R2), I've uploaded to SkyDrive...
2013-01-11
19,073 reads
Querying the Procedural Cache: Just in Time for the New Years’
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for...
2012-12-26
1,486 reads
Blogs
Join SQLSat Memphis Virtually This Saturday
By Will Assaf
Looking forward to presenting at SQLSaturday Memphis virtually this weekend! Both my wife and I...
Failing SQL Agent Jobs – Part 4
By gbargsley
Here we are, another Tuesday!! It is time for our Fourth and final installment...
I Want PASS to Survive
By Steve Jones
I want PASS to survive. I can say that unequivocally, because this organization has...
Forums
If no record (from table variable) found in a table return null value instead
Hello, I am sure this is simple but I just can't get what I...
In search of Database scripts version control strategy or process
Hello! I am looking for strategy/process that helps to achieve database scripts version control...
Calculating offset (adding days to a date but keeping same day name of week)
Ok, I've written a bit of code and it's horrible and looks terribly inefficient...
Ask SSC