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

A Wonderful Weekend in Riyadh, Kingdom of Saudi Arabia, Speaking SQLGulf #1, Alfaisal University


Thanks to the perseverance of SQL MVP Shehap El-Nagar’s invite last year, this brave man from the Saudi Ministry of Higher Education, managed to organise a great inaugural event.  After the longest visa request process in my life, and twice, since originally his goal was to host this event in…

Read more

0 comments, 203 reads

Posted in The Database Hive for SQL Server DBAs on 11 September 2014

Security Updates released in MS14-044, and An Approach Microsoft’s Incremental Servicing Model

On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server, to deal with potential Denial of Service attacks and an exploit in Master Data Services. After attempting to make my way through hundreds of instances already, and all…

Read more

0 comments, 641 reads

Posted in The Database Hive for SQL Server DBAs on 22 August 2014

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, 215 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

1 comments, 1,306 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, 534 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, 881 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, 468 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, 724 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, 720 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, 690 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, 1,003 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,607 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, 9,255 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, 879 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,588 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, 743 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, 947 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, 1,046 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, 7,574 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, 868 reads

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

Older posts