Generate Deadlock Summary Information (SQLServerCentral 12/13/2016)

Click here to subscribe to Sqlservercentral.com

8 years ago

Html
Text

A community of more than 1,600,000 database professionals and growing

Featured Contents

Generate Deadlock Summary Information A Big Deal : SQL Server 2016 Service Pack 1 SSIS Naming Conventions 2.0 (From the SQLServerCentral Blogs)

The Voice of the DBA

DBAs Need to Learn to Develop

This editorial was originally published on Jan 7, 2014. It is being re-run as Steve is at SQL in the City today.

My first exposure to computers was as a child, learning to program in BASIC, Assembler, and Pascal. From there I moved into other areas, such as networking and system administration. I learned about a variety of technologies before focusing on databases, but I found that my knowledge from other areas of computing helped me be a more successful DBA at quite a few jobs.

Last year we put on a number of SQL in the City Seminars where Grant Fritchey and I talked about development practices. We give a variety of advice and practices that you can use, but one of the best things that we say in our half day event comes from Grant. He says that DBAs need to "Follow the local development paradigm as much as possible."

I completely agree with this. I think that many of the practices of building software, as flawed as they might be, are good ideas that many developers use on a regular basis. They know how to work in a flexible manner, tracking their code and keeping it under control, and fixing problems in a rapid manner. As immature as the software development process can be, there are things that we, as DBAs, can learn.

As SQL Server continues to grow as a platform, there are more and more enhancements, many of which involve programmatic capabilities expanding. I highly recommend that DBAs think about learning more about programming, and specifically a .NET language, if you've never used one. If you have, consider brushing up those skills.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

Version control
your database
changes with
SQL Source Control.
Improve team collaboration,
get a full change history, and avoid deployment problems.

Question of the Day

Today's Question (by Steve Jones):

Where can I store the certificates for my Always Encrypted Column Master Key?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Security.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

SQL Server T-SQL Recipes

SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

How can I get the version of PowerShell I'm using from a PowerShell command prompt?

Answer: $PsVersionTable.PSVersion

Explanation:

There is a built in environment variable called $PsVersionTable. The PSVersion property in here is the version of PoSh you are running.

Ref: How To Check Current Installed Version of PowerShell - https://blogs.msdn.microsoft.com/brijs/2011/03/11/how-to-check-current-installed-version-of-powershell/

Check Your Version of PowerShell - http://www.computerperformance.co.uk/powershell/powershell-version-check.htm

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Administration

SSIS in SQL 2016 - Hi All, What am I missing. I have installed SQL 2016 and thought I had installed all the services and I...

SQL Server 2014 : Administration - SQL Server 2014

Stored Procedure help - I wrongly posted this in SQL Server 2005 so re-posting here as I couldn't move it. I'm running SQL Server...

Backup Database is terminated Abnormally Failed on SQL Server 2014 RTM - My Database backup is not working in SQL 2014 RTM version. It works fine on SQL Server 2008 R2. All...

SQL Server 2014 : Development - SQL Server 2014

Long running Insert stored proc - Hi all, I was wondering if someone could help me figure out why this Insert statement is taking 9 minutes to...

SQL Server 2012 : SQL 2012 - General

How to identify that Dynamic Sql fail? - I have created one trigger,inside it executing dynamic sql. Here is sample script When I specifying @Text to some value,it work...

Copy BAckup Files to Non Prod servers - Hello Experts, I need to copy backup files from Prod server to Non Prod server but the problem is both are...

sp_send_dbmail - How do I go about getting the results from a SQL Query into and file and e-mail it? [code="sql"] USE msdb; GO EXEC sp_send_dbmail...

Let the optimizer do it's thing -- wrong - I've heard this advice everywhere. Don't do things to change the way the sql optimizer produces plans etc. "it's smart...

Help with query to find duplicate fields from one column and return relevant information - Hi All I am new to SqL and would appreciate any help with the following: I have a written a query where...

SQL Server 2012 : SQL Server 2012 - T-SQL

trying to get rid of clustered index scan - I have statement below which does a merge join but does a clustered index scan with over 2 million rows...

Converting time - from "seconds after midnight" - Hello all, We have time saved in our db in a seconds after midnight format and need to convert it to...

SQL Server 2008 : SQL Server 2008 - General

I'm scared to delete log file - Hi, I have two files i.e [b] .ldf[/b] and [b].mdf[/b] in my disk. As we know these are normally SQL Server...

Confusion Over OR and And Operators - Suppose I want to find customers in the customers table who are not in the US or the UK. To me...

Query to join three tables but filter out subset of the data - I'm struggling to develop a query to pull data from a few tables while excluding some portion of the data....

SQL Snapshot - Hello, I need to be able to test something (which will change some data on the big databases) and after revert...

SQL Server 2008 : T-SQL (SS2K8)

Last 2 years and YTD - I am losing my mind..:) Can someone please help me with how to implement: YTD Plus the prior 2 Full Years (In...

SQL Server 2008 : SQL Server Newbies

Loading CSV files into SQL Server Database tables - Does any one know of an open source tool that I can use to load data from csv files into...

Reporting Services : Reporting Services

SSRS 2012 Standards for Report Server Configuration and Report Development? - Just wondering if anyone has some suggestions on standards for SSRS Report Server Configuration and Report Development? I have come...

Data Warehousing : Integration Services

Variable needed for dynamic ff destination not being retrieved from sql - I have an SSIS package that has an Execute SQL task to [code="sql"]SELECT SUBSTRING(MAX([InvoiceDate]),1,2) as Monthsql FROM BJmm[/code] (Table has a...

Data Warehousing : Strategies and Ideas

Good to have Multiple Data Warehouses? - Interesting debate came up on data warehousing. Is it good to have multiple data warehouses or just one? To add some...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.

Share on

Other newsletters from Sqlservercentral.com

A Trigger... just not that kind Sqlservercentral.com
Yesterday at 05:10
Configuring Maintenance Plans in SQL Server (20 24-02-21) Sqlservercentral.com
Last Friday at 08:17
How to Resolve SQL Server Database Stuck in Rec overy Pending State (2025-02-19) Sqlservercentral.com
Last Wednesday at 08:13

More newsletters from Sqlservercentral.com

Generate Deadlock Summary Information (SQLServerCentral 12/13/2016)

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

DBAs Need to Learn to Develop

Featured Contents