When was my server last rebooted? Who shutdown my machine? Read on to see how easy it is to find out using the Windows Server Event Logs.Read More »
Category: SQL Server
How to Load SQL Server Error Log into Table for Analysis
A while ago I wrote a post about the SQL Server error log. Today I will show how to load the SQL error log into a table for analysis via T-SQL.
Read on to see a couple of ways to traverse all the error logs and load into a table for analysis.Read More »
SQL Server Presentations
I just uploaded some sample presentations I did. You can find them on the Resources page. Both talks were given at SQL Saturday Sacramento.Read More »
SQL Server 2008 – Come Join Us
This July marked the end of life for Microsoft SQL Server 2008 and 2008R2. Let’s raise a glass to toast / pour some liquor out / reminisce about the past…Read More »
I’m Speaking – SQL Saturday Sacramento 2019!
- Database Corruption! Preventing Disaster to your Database
- Environmental SQL Server Troubleshooting
Read on about my presentations…
How to Generate Scripts In SQL Server
There are multiple methods for exporting data from SQL Server. We will explore a few and focus on the “Generate Scripts” feature in SSMS.Read More »
SQL Server Drop Tables in Bulk – 2 Methods
There are times when you may find yourself needing to drop many tables in your database but not all. Some criteria defines what must go. It could be archived tables, tables before or after a certain date time stamp, dummy data tables, etc.
Let’s look at 2 simple methods for dropping lots of tables in your database.Read More »
I’m Speaking – SQL Saturday Phoenix 2019!
I’m Speaking – SQL Saturday Raleigh 2019!
When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment.
Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.
In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
If you want a preview of the talk and some supplemental info please look at these:
- Environmental Checks – Overview
- SQL Server Environmental Diagnostics Guide
- Windows Server Environmental Diagnostics Guide
- VMware Environmental Diagnostics Guide
These are all available under the Resources menu at the top of the page.
T-SQL Tuesday #113 – What Do You Use a Database For?
The topic for this months T-SQL Tuesday #113 hosted by Todd Kleinhans (Blog / Twitter) is about “what do YOU use a database for”. We work all day, night, and weekend sometimes on our database craft. Todd asks:
So what do you use databases for in your personal life that you are willing to share?
Read on to hear my story.Read More »