SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2016

MSDB log file grown large – SLEEP_MSDBSTARTUP waittype

Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB whereas Data file is only 1GB for MSDB on server.

Findings: We found system owned open transaction in MSDB which is causing issue.

Transaction information for database ‘msdb’.

Oldest active… Read more

0 comments, 804 reads

Posted in MSSQLFUN on 30 November 2016

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window.

It threw me off since I was trying to write some code and hadn’t expected it. I clicked Escape, Enter, a few things and was getting frustrated when it disappeared.

I ignored it until I saw the window again… Read more

4 comments, 1,799 reads

Posted in The Voice of the DBA on 30 November 2016

This Week in Data – Episode 14 (Hacking Your Professional Development)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss hacking your own professional development.

Having a plan for your professional development is essential when tackling your career goals. You need to have… Read more

0 comments, 801 reads

Posted in Devin Knight on 30 November 2016

Query Tuning 101: Debugging a procedure

I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds to complete. Overall the code wasn’t too complex but getting to the root cause did surprise me a bit.

We run a mixture of SQL Server 2008 R2 and SQL… Read more

0 comments, 4,275 reads

Posted in Confessions of a Microsoft Addict on 30 November 2016

Reflecting on Ten Years of SQLSaturday

It’s hard to believe it’s been more than 10 years since we started the planning for the first event in Orlando. The success of the idea seems obvious now – surely the time was right for something to happen in our space. Back then though it was far from obvious.… Read more

8 comments, 1,138 reads

Posted in SQLAndy on 30 November 2016

Using OUTPUT with a field list.

I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a clause that lets you output the changed data from an INSERT, UPDATE, DELETE, or MERGE statement. One of the comments on the article was a question… Read more

2 comments, 678 reads

Posted in SQLStudies on 30 November 2016

SQL Server & Containers – Part Three

This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing that custom image up to the Docker repository.

Let’s quickly check that we have our custom image, so run (in an admin powershell session):-

docker images

If you’ve followed Part… Read more

5 comments, 1,986 reads

Posted in The DBA Who Came In From The Cold on 30 November 2016

CISL 1.4.1 is released

Just one month later after the 1.4.0 release of CISL, I am here again blogging about the new release 1.4.1 which besides bug-fixes and small improvements introduces support for Columnstore Indexes on any edition of SQL Server starting with SQL Server 2016 Service Pack 1 and the initial bits for… Read more

0 comments, 615 reads

Posted in Niko's blog on 30 November 2016

SQL Server 2016 SP1 – Rocking RELEASE!!!

Last week, I did a presentation titled "SQL Server 2016 SP1 – Rocking RELEASE!!!" to Singapore SQL User Group. The Presentation was about the things I covered over here and few more cool features released with SQL Server 2016 SP1. The best part of it was it was recorded :) This…

Read more

0 comments, 817 reads

Posted in SQL and SQL Only on 29 November 2016

Rate a Session for GroupBy

One of the things that I struggle with is understanding whether a session at a conference like a SQL Saturday is worth watching. I also struggle writing abstracts and attracting people to my own sessions, so I think the idea of GroupBy allowing rating and reviewing of abstracts in advance… Read more

2 comments, 753 reads

Posted in The Voice of the DBA on 29 November 2016

Analytics Platform System 2016 Release

Microsoft has a new release for the Analytics Platform System (APS).  This appliance update is called APS 2016 and has been released to manufacturing and is now generally available.  APS is Microsoft’s scale-out Massively Parallel Processing fully integrated system for data warehouse specific workloads.

This release is built on the… Read more

4 comments, 493 reads

Posted in James Serra's Blog on 29 November 2016

VMware vSphere 6.5 breaks your SQL Server vNUMA settings

VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to unexpected changes in behavior. It might even slow down your SQL… Read more

10 comments, 3,292 reads

Posted in Technobabble by Klee from @kleegeek on 29 November 2016

Power BI Custom Visuals Class (Module 27 – Synoptic Panel)

In this module you will learn how to use the Synoptic Panel Power BI Custom Visual.  The Synoptic Panel is really one of the more impressive visuals available. This visual allows you to take an image and plot data on different regions that you define.

Module 27 – Synoptic Panel

Read more

0 comments, 2,052 reads

Posted in Devin Knight on 29 November 2016

Notes from our 3rd Student to IT Pro Seminar

Concurrent with SQLSaturday Orlando we ran our third student seminar. This is our way of giving back to the college that so kindly gives us free space for the event and of encouraging students to see IT as a great career choice.

  • Attendance was down last year, not good. This…

Read more

0 comments, 667 reads

Posted in SQLAndy on 29 November 2016

Announcing Minion CheckDB release date!

Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup and Minion Reindex...and it's coming in early 2017.

The post Announcing Minion CheckDB release date! appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 1,029 reads

Posted in SQL Awesomesauce on 28 November 2016

Validating a Set of Database Scripts using DLM Automation

The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or confusing, but they aren’t. This is part of a series of posts that examine how you use each one.

Previously I looked at New-DatabaseConnection. In this post, I’ll go through… Read more

0 comments, 1,773 reads

Posted in The Voice of the DBA on 28 November 2016

Database Clone

There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is another. There are even third party tools that will help with that. However, each of these has a problem. It’s moving all the data, not just once, but twice. You… Read more

1 comments, 2,451 reads

Posted in The Scary DBA on 28 November 2016

Notes From SQLSaturday Orlando 2016

This year we held our 10th SQLSaturday, a very nice milestone to hit. I’ll reflect in a separate post on the growth and future of the overall franchise – there’s a lot to think about – but I’ll mostly keep this post specific to the event itself.

This turned out… Read more

0 comments, 702 reads

Posted in SQLAndy on 28 November 2016

Easy to read CHECKDB

If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC CHECKDB in most if not all of those lists. Unfortunately, the output can be long, overwhelming and a more than a bit difficult to read. So here are a few… Read more

9 comments, 2,389 reads

Posted in SQLStudies on 28 November 2016

How to backup local SQL database and restore to Azure SQL database

Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure SQL database. I found that there is new option available to generate the scripts for Microsoft SQL Azure database using Generate Scripts option. Let me walkthrough step by step on…

Read more

3 comments, 930 reads

Posted in Kapil Blogs on 28 November 2016

Older posts