-
Exporting a Procedure for Backup
4August 31, 2012 by Mike Hillwig
Working in my environment, I’ll get the occasional odd requirement pop up. Â Frequently, clients will write a new version of …
keep readingCategory Uncategorized | Tags: automation, backup, code, dynamic sql, export, tsql
-
Cranky Series: Database Servers are that and that alone
11August 31, 2012 by Mike Hillwig
Welcome to the last post in my How Not to be a Cranky DBA series. This has been a lot …
keep readingCategory SQLServerPedia Syndication | Tags: cranky, performance, ssas, ssis, ssrs, sss
-
Cranky Series: Limit Access to the SA and Service Account Passwords
12August 30, 2012 by Mike Hillwig
I swear that some developers have no clue when it comes to security. At my former employer, we had a …
keep readingCategory SQLServerPedia Syndication | Tags:
-
Cranky Series: Reserved Words are just that, Reserved.
6August 29, 2012 by Mike Hillwig
In the environment where I work today, we have a database called SECURITY. This makes me want to physically harm …
keep readingCategory SQLServerPedia Syndication | Tags:
-
Cranky Series: Test Restores. Frequently.
11August 28, 2012 by Mike Hillwig
I’m a firm believer that while backups are important, restores are absolutely essential. Any DBA will be able to tell …
keep readingCategory SQLServerPedia Syndication | Tags:
-
Motivating a Staff
4August 27, 2012 by Mike Hillwig
I’ve been in my current job for about 13 months now. They brought me in as a contractor in July …
keep readingCategory Uncategorized | Tags:
-
Cranky Series: Set your File Growth Increments
9August 27, 2012 by Mike Hillwig
One of the things that drives me nuts about working with Oracle DBAs is that they think installing and configuring …
keep readingCategory SQLServerPedia Syndication | Tags:
-
Cranky Series: Your Server is NOT a Workstation
8August 24, 2012 by Mike Hillwig
Welcome to the Friday edition of my How Not to be a Cranky DBA series. It’s been a rough week, …
keep readingCategory SQLServerPedia Syndication | Tags:
-
Cranky Series: Document. Document. Document.
10August 23, 2012 by Mike Hillwig
I used to hate writing documentation. Now I see it as a necessary evil of my job. But I also …
keep readingCategory SQLServerPedia Syndication | Tags:
-
Cranky Series: Set Min and Max RAM
7August 22, 2012 by Mike Hillwig
Thank you, Brent Ozar. This is something I learned from Brent when he was talking about running SQL Server in …
keep readingCategory SQLServerPedia Syndication | Tags: