Posts Tagged ‘sql’
-
Crystal Reports Formula for MSDB Dates and Times
3September 10, 2009 by Mike Hillwig
As a DBA, I find myself spelunking through data and often having to present it in a somewhat human-friendly format. …
keep readingCategory SQLServerPedia Syndication | Tags: crystal reports, msdb, sql, sql server, sysjobhistory
-
Backing Up for my Primary/Secondary Environments
34September 8, 2009 by Mike Hillwig
Every environment is different, and that means everyone does backups differently. I thought I’d talk about how I do it …
keep readingCategory SQLServerPedia Syndication | Tags: backup, restore, sql, sql server
-
Using sysjobhistory to Find What’s Running Longer than Usual
21September 8, 2009 by Mike Hillwig
We all have SQL Agent jobs that run periodically. Wouldn’t it be nice to know that something ran longer than …
keep readingCategory SQLServerPedia Syndication | Tags: sql, sql agent, sql server, sysjobhistory
-
An Object by Any Other Name
0September 8, 2009 by Mike Hillwig
In my career, I’ve seen a lot of database objects. And I’ve seen a lot of names, both good and …
keep readingCategory SQLServerPedia Syndication | Tags: objects, sql, sql server, standards
-
Giving Microsoft Access a Seat at the Table
2September 2, 2009 by Mike Hillwig
Ask any DBA what they think of Microsoft Access, and you’ll rarely see a smile. Perhaps you’ll get a laugh, …
keep readingCategory SQLServerPedia Syndication | Tags: access, dba, sql, sql server