Deadlock Monitoring
There are four different ways you can get information about deadlocks in your system. These are:
traceflag 1204traceflag 1222trace eventsextended eventsFor...
2012-01-27 (first published: 2012-01-23)
3,074 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
Stop PIPA & SOPA
I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six...
2012-01-18
1,909 reads
Database Backups: Things You Need To Do Now
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...
2012-01-16 (first published: 2012-01-11)
5,132 reads
Friday SQL Nugget #1
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like...
2012-01-13
1,433 reads
PASS Summit 2012 Evaluation Results
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...
2011-12-19
1,721 reads
SQL Saturday #104: Colorado Springs
I’ll be presenting at the Colorado Springs SQL Saturday on January 7th of 2012. The session is called Seven Ways...
2011-12-14
1,929 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.
2011-12-14
6,689 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,140 reads
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,693 reads
A DBA is a Data Professional
DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of database software, such as Microsoft SQL Server. They are concerned with gathering, storing and presenting data to data consumers, which includes virtually anyone in the modern world.
2011-12-08
1,076 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Simple Junction table design question
I have a disagreement with the programming team on an app that I designed....
Sql query to check the status change for an item
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
Migration of on-premises SQL Server to an AWS PostgreSQL database
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers