Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

How to Fix that Never-Ending Join Dragging Down the Whole DB Server Instance – Pre-Populate the Largest Bugger in Temp with Indexes


Now that it has been a good five years I have been blogging away here and on SSC, the editors recently thanked us for our work. They also provided valuable feedback that we should give real-world situations that DBAs encounter.  The following has a target of optimising performance, from…

Read more

0 comments, 136 reads

Posted in The Database Hive for SQL Server DBAs on 12 May 2014

Microsoft Project Migration Template for the move to SQL 2012


For those planning a move to SQL Server 2012, although this process can apply for many Database Migrations, perhaps this Microsoft Project Migration Template could help? *
In this plan, there are so many possible steps, it is better to trim down from too many to just those applicable instead…

Read more

0 comments, 646 reads

Posted in The Database Hive for SQL Server DBAs on 13 January 2014

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 a very friendly crowd at MyWebGrocer and presented all I know about AlwaysOn for the Vermont Professional Association for SQL Server, run by Roman Rehak.
I shall be placing…

Read more

0 comments, 364 reads

Posted in The Database Hive for SQL Server DBAs on 16 December 2013

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 issues, or for simple text validation of what components were added during an installation process. This is the folder I want to point out: \\rootDrive:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log

Read more

0 comments, 542 reads

Posted in The Database Hive for SQL Server DBAs on 11 December 2013

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 profile and actually completing it. It is pretty much the ultimate business networking tool-until replaced by a competitor of course! Much of facebooks’ features have been mimicked into the…

Read more

0 comments, 366 reads

Posted in The Database Hive for SQL Server DBAs on 9 October 2013

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 method to avoid the SysAdmin fixed Server role in SQL Server for DBAs and Monitoring/Auditing Accounts, thanks to extensive explicit permissions and taking full advantage of SQL 2012 User Define…

Read more

4 comments, 426 reads

Posted in The Database Hive for SQL Server DBAs on 10 September 2013

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 Studio Registered Server list. Ever since March I have been updating our list on nearly a daily basis, since I believe this is very important to managing multiple SQL Servers.… Read more

0 comments, 559 reads

Posted in The Database Hive for SQL Server DBAs on 1 August 2013

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 Server 2008 R2:
a Managed Service Account.
This type of account is tied to a machine, and cannot be locked out, and seems to be a saviour for vigilant DBAs…

Read more

0 comments, 480 reads

Posted in The Database Hive for SQL Server DBAs on 21 June 2013

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 is formerly known as the Microsoft Terminal Services Connector accessible from the command mstsc in Run, or from a Command Prompt.  What most do not realise, however, is that there… Read more

0 comments, 870 reads

Posted in The Database Hive for SQL Server DBAs on 25 February 2013

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 2005 in production who might be there for a little while: there’s a decent feature you can take advantage of too that is very expensive to do in SQL 2008.… Read more

0 comments, 1,422 reads

Posted in The Database Hive for SQL Server DBAs on 8 February 2013

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 another complete step by step guide for a Microsoft SQL Server installation. This time the Guide is for a SQL Server 2012 with Service Pack 1 installation, because I… Read more

0 comments, 6,972 reads

Posted in The Database Hive for SQL Server DBAs on 11 January 2013

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 peace, happiness and health for 2013.

The goal of this post is to aid in the understanding of the procedure cache and execution plans to ensure we use fewer resources,… Read more

0 comments, 813 reads

Posted in The Database Hive for SQL Server DBAs on 26 December 2012

Another Dive into Transaction Log File Forensics


 Over the past three years since I first took a look at the insides of a Transaction Log file, I have noticed some more great products to enable forensics such as ApexSQL ( which makes the job simple), Lumigent Log Explorer, and other Free tools mentioned below, as well…

Read more

1 comments, 4,113 reads

Posted in The Database Hive for SQL Server DBAs on 6 November 2012

Quebec Human Rights Commission Ignores Racism Documented by CRT Judge (Civil Evidence), Ignores E-mail Evidence & Botches Up Investigation

After seeking justice in this matter for years, I am obliged to bring this issue up again (since it affects millions of people in our province), regarding multiple incidents that occurred, while working as a Database Administrator for the Provincial Government.

This is just a quick post to make public…

Read more

0 comments, 665 reads

Posted in The Database Hive for SQL Server DBAs on 2 August 2012

Latest Presentation on SQL Server Mirroring Given at Transcontinental's Offices

With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this afternoon.
Please find the Presentation Slide Deck here on SkyDrive.




Contenu - Contents


Introduction to-à Microsoft SQL Server Mirroring – Haut disponibilité avec des bases de données en mirroir. An…

Read more

0 comments, 824 reads

Posted in The Database Hive for SQL Server DBAs on 14 June 2012

Optimise Your Disk Subsystem I/O with An Index File Group and Index Compression



As a DBA who is always seeking solutions to performance bottlenecks, amidst the daily rituals of validating backups and other regular tasks, profiting from File Groups on differing disk subsystems, in this case for Indexes, arose as flavor of the week. With this option, note that I am assuming one…

Read more

0 comments, 933 reads

Posted in The Database Hive for SQL Server DBAs on 6 June 2012

Top 20 Reasons Why Bill 101 Is a Nuisance to Modern Quebec Society: Greatest Hits of the Tyranny of Bill 101


Quebec's Shameful, Coercive Language Law

‘Je me souviens’ les palmarès Top 20 de la loi 101 sacrée qui nuit à la société Québécoise.

The author is well aware of the typical and detestable knee-jerk reaction this pamphlet shall provoke, but my francophone brethren know me well enough to understand that…

Read more

6 comments, 6,324 reads

Posted in The Database Hive for SQL Server DBAs on 9 May 2012

SQL Server 2012 Synopsis - Mission Critical Applications Combined With The Fantastic 12 New Features or "The Baker's Dozen" as described by Microsoft this Week


Notes by Hugo S., Print Screens from three Microsoft Presentations


7 December, 2011 with Additions combined from early February 2012 day-long presentation of Server 2012’s Top 12 new features. Thank you Frank Wiemer (Data Platform head, Eastern Canada, based in Montreal, for your presentation slides). With these notes, I have…

Read more

0 comments, 798 reads

Posted in The Database Hive for SQL Server DBAs on 27 March 2012

Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)


Free E-Book: Introduction to SQL Server 2012

Ross Mistry and Stacia Misner have again done a wonderful job on this free e-book


You can the full details of the introduction here.



The book contains 10 chapters and 268 pages:

PART I   DATABASE ADMINISTRATION (by Ross Mistry)
1.   SQL…

Read more

0 comments, 1,436 reads

Posted in The Database Hive for SQL Server DBAs on 20 March 2012

Activity Monitor in SQL Server 2012: an Improved Embedded Optimisation Gizmo for the Thrifty DBA

Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen (SQLserverBible.com), on this subject, the following is a re-introduction to one of our favorite Management Studio features: Activity Monitor. 
To use AM, right click on a SQL Server…
Read more

0 comments, 7,683 reads

Posted in The Database Hive for SQL Server DBAs on 18 March 2012

Older posts