Skip to content
DBA Fire
SQL Server, MySQL and WordPress Specialist
  • Contact Us
  • About Me
  • Resources

Category: General

Database/General

Do I need to Patch SQL Server for Meltdown and Spectre?

Posted on January 11, 2018 by Rob StGeorge / 1 Comment

The news has been full of information around critical patching for Meltdown and Spectre over the last couple of weeks. Most of the information out there is rela...

General

How to Find the Best Company to Work For (Culture vs Career)

Posted on December 28, 2016 by Rob StGeorge / 0 Comment

As I take a short vacation at the end of the 2016, I have been thinking about the different company cultures that I have been part of over the last few years. I...

Database/General

SQL Interview Questions For SQL DBA

Posted on December 8, 2014 by Rob StGeorge / 0 Comment

In the last couple of jobs that I applied for I was subjected to technical SQL interview, by people that were not technical SQL people. This is not ideal, and I...

Database/General/Troubleshooting

4 Shortcuts to clearing up disk space in record time on your SQL Server

Posted on August 11, 2014 by Rob StGeorge / 0 Comment

You know the drill, everything is running along smoothly and then suddenly it’s panic stations! Oh no the database server has run out of space and everyon...

General/Troubleshooting

How to filter a SQL Profiler Trace

Posted on April 19, 2014 by Rob StGeorge / 0 Comment

The easiest way I have found to filter down the results of a profiler trace is to dump it into a table and query the results from there. This gives you a simple...

Database/General/Training Resources

SQL Server Audio

Posted on May 27, 2013 by Rob StGeorge / 0 Comment

Lately in my new role I have been hitting the traffic alot and spending considerable time driving both to and from work. To make the most of this downtime I hav...

Database/General

Show progress of shrink file command

Posted on January 21, 2013 by Rob StGeorge / 0 Comment

If you are ever shrinking a large data file (bad practice but necessary sometimes) and need to get some idea of the progress you can run the below SQL to get so...

Database/General

Collation Errors Running a SQL Query

Posted on December 10, 2012 by Rob StGeorge / 0 Comment

If you are ever trying to join tables from different databases that are using different collations you may experience the dreaded… Msg 468, Level 16, State 9, L...

Database/General

How to restore Master DB – SQL Server 2008 R2

Posted on August 24, 2012 by Rob StGeorge / 1 Comment

When you are a DBA it can be almost dull at times, you keep on top of your checks, try to correct any problems that may pop up and generally keep things ticking...

Database/General

How to quickly delete sql agent jobs – via T-SQL

Posted on January 15, 2012 by Rob StGeorge / 0 Comment

You can run the below to create a dynamic script that outputs the t-sql that you run to delete a bunch of SQL agent jobs. Another time saver in large environmen...

Posts navigation

1 2 Next »

Most Helpful Articles

  • Newid() vs Newsequentialid() - Performance Of, Differences Between and Examples
  • Cost Threshold For Parallelism - Best Practice and Recommendations
  • Convert Varchar Column to Nvarchar - Techniques and Best Practices
  • TSQL Email Verification - Easy Way To Check Addresses are Valid formats
  • How To Renew a SSL Cert on Reporting Services
  • sp_executesql Stored Procedure Examples, Output and Return Values
  • How To Change the Owner of Availability Group Endpoints
  • How To Generate A Random Number Betweeen 1 and 10 With SQL Server
  • How To Create A Unique Constraint With Conditional Filter
  • What is the Difference Between + And Concat Function In SQL?

Recent Posts

  • How to Reinstall SQL Server Without Breaking Availability Groups
  • How to Fix Availability group failed to process remove-database command
  • How To Renew a SSL Cert on Reporting Services
  • Configuring Kerberos for SSRS – Lessons Learned
  • Google Sandbox Case Study

Sections

  • Cloud
  • Clustering
  • Configuration
  • CRM Integration
  • Data Science
  • Database
  • Database Mail
  • Dates
  • Disaster Recovery
  • Facebook
  • General
  • Google Analytics
  • Google Plus
  • IIS
  • Internet Marketing
  • iSCSI
  • Logshipping
  • Mirroring
  • Mobile
  • MySQL
  • off topic
  • Performance
  • Permissions
  • Recommended Resources
  • Replication
  • Server Core
  • Service Broker
  • Service Packs
  • Social Media Marketing
  • SQL 2012
  • SQL Quick Tips
  • SSIS
  • SSRS
  • T-SQL
  • Training Resources
  • Troubleshooting
  • Uncategorized
  • Views
  • Webhosting
  • Websites
  • WordPress

The owner of this website, dbafire.com, is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking dbafire.com Reviews to Amazon properties including, but not limited to, amazon.com, endless.com, myhabit.com, smallparts.com, or amazonwireless.com. The site is also a member of other affiliate programs.

© 2019 DBA Fire
Powered by WordPress | Theme: Graphy by Themegraphy