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

Archives: August 2016

Why SQL Server Database Is In Recovery Mode?

The SQL Server whenever it restarts all the databases goes into the recovery mode. In this state the database comes back in online mode and has a consistent state. It contains three sub phases within this process. Roll forward and rollback are the process contained in this phase. The detailed… Read more

0 comments, 67 reads

Posted in Ganapathi's MSSQLLover on 29 August 2016

Remote Desktop Workflow Improvements

Remote server management is a fact of life for folks involved with sql server. Since we work so often with remote machines I looked into a few tools that provided a better workflow than the default Microsoft tools. This one came out as the winner by far.

A better remote…

Read more

0 comments, 38 reads

Posted in SQL Barbarian on 29 August 2016

Making Start-Demo work with multi-line commands without a backtick

I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the PowerShell Conference in Hanover I started to make use of it in my presentations.

Start-Demo was written in 2007 by a fella who knows PowerShell pretty well :-)  https://blogs.msdn.microsoft.com/powershell/2007/03/03/start-demo-help-doing-demos-using-powershell/

It… Read more

0 comments, 361 reads

Posted in SQL DBA With A Beard on 29 August 2016

Remote Desktop Workflow Improvements

Remote server management is a fact of life for folks involved with sql server. Since we work so often with remote machines I looked into a few tools that provided a better workflow than the default Microsoft tools. This one came out as the winner by far.

A better remote…

Read more

0 comments, 376 reads

Posted in SQL Barbarian on 29 August 2016

CISL 1.3.1 is released

I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!

Do not get confused by the small incremental of the build version – this release is something that anyone should be upgrading to, because of the all new functionalities… Read more

0 comments, 360 reads

Posted in Niko's blog on 28 August 2016

When should I use a CTE?

If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d be Mark Cuban. With that said I thought it would be a good idea to ask if a CTE was actually the right solution or if it’s just the… Read more

0 comments, 534 reads

Posted in Confessions of a Microsoft Addict on 27 August 2016

Understanding the Different States of SQL Database

Overview

There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in SQL server.

At once, the database is only in one state, which may be any one of the following:

  • Online
  • Offline
  • Restoring
  • Recovering
  • Recovery Pending
  • Emergency
  • Suspect

In this… Read more

0 comments, 371 reads

Posted in PowerSQL By Prashanth Jayaram on 27 August 2016

Organizing a SQL Saturday – Part 1 – Why Do It?

To kick off this series, I thought it would be worthwhile to discuss why it is I step up to help lead the effort to pull this event together. I know it did because it helped change mine. Without hesitation, which I now question sometimes, I stepped up and said… Read more

0 comments, 313 reads

Posted in WaterOx SQL on 26 August 2016

An MCM teaches COMMENTS at SQL Saturday OKC

Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events page! (Direct link to WMV.) Tomorrow (as of the blog’s publish date) at8:30am, I will be teaching “T-SQL’s Hidden Support Feature” at SQL Saturday Oklahoma City (totally free,… Read more

0 comments, 380 reads

Posted in SQL Awesomesauce on 26 August 2016

TGI SQL Friday – Weekly round up 26th August 2016

The SQL Server news this week is there is no news!


No this is not the 1930’s BBC.

There are no links here this week because I have been on holiday and not keeping up with latest blogs and articles so I don’t have much to post this Friday.…

Read more

0 comments, 228 reads

Posted in The SQL DBA in the UK on 26 August 2016

I’m speaking at SQL Saturday 563 in Dallas

This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was a great time. I enjoyed hanging out with all the attendees and speakers. Who wouldn’t want to have a chat with Kalen Delaney or Bob Ward? The Dallas edition of… Read more

0 comments, 332 reads

Posted in Confessions of a Microsoft Addict on 25 August 2016

PASS Board Update

Time for another update.

The minutes for the June in-person meeting have been approved and are now ready for your information. We accomplished a lot in the two days and you can read what we did there. I’m pleased about two things. First, while it took until the July meeting… Read more

4 comments, 949 reads

Posted in The Scary DBA on 25 August 2016

SQL Saturday–Viking Edition

I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side trip on Friday before the actual event. The actual training will be at the Noroff campus in Oslo.

This is my first trip to Norway, and while it… Read more

0 comments, 1,800 reads

Posted in The Voice of the DBA on 25 August 2016

Talking of checkpoint

I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine and how to confirm if SQL Server starts to checkpoint the databases on the server – obviously it makes sense … Continue reading

Read more

1 comments, 85 reads

Posted in All About SQL on 25 August 2016

Speaking at SQLSaturday #555, Munich 2016

I am very honoured to share that I have been picked up to speak at the German SQLSaturday in Munich 2016 on the 8th of October. The very first SQLSaturday in Germany was one of my first international SQLSaturdays back in 2012 and it was in Munich – I have… Read more

0 comments, 370 reads

Posted in Niko's blog on 25 August 2016

Calculating DTU in Azure SQL Database

A few months ago, I posted a question over on ask.sqlservercentral.com.  In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL?  No one answered, so this motivated me get off my butt and answer my… Read more

4 comments, 1,146 reads

Posted in John Sterrett on 24 August 2016

Output into a Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I often see people struggling to use triggers for auditing, or having issues with building them to handle multi row updates. However, there’s another choice: the OUTPUT… Read more

0 comments, 1,076 reads

Posted in The Voice of the DBA on 24 August 2016

This Week in Data – Episode 1 (The Value of Certifications)

We know you you’ve been dying to know, what is TWID?  Drumroll please…. We’re excited to announce the launch of This Week In Data!  This Week In Data is a weekly video podcast hosted by Adam Jorgensen and Devin Knight that discusses important news and topics within the… Read more

1 comments, 341 reads

Posted in Devin Knight on 24 August 2016

SQL Server 2016 real-time operational analytics

SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both analytics (OLAP) and OLTP workloads on the same database tables at the same time.  This allows you to eliminate the need for ETL and a data warehouse in some cases… Read more

2 comments, 423 reads

Posted in James Serra's Blog on 24 August 2016

1 Day Workshop – Columnstore Deep Dive (in German) on 6th of October 2016

To support more and more people jumping to Columnstore INdexes, OH22 have decided to open another public 1-day deep dive workshop on Columnstore Indexes.

This public workshop will take place in Munich on 6th of October 2016, at Microsoft Germany office in Cologne (Notice that it will be in German) Read more

0 comments, 303 reads

Posted in Niko's blog on 24 August 2016

Newer posts

Older posts