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

Archives: May 2015

Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6

Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp. …

Continue reading Read more

0 comments, 834 reads

Posted in Kapil Blogs on 30 May 2015

Finding gaps or missing dates in a date range using TSQL

Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all the days that he missed.

The expected result would look something like… Read more

5 comments, 8,323 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 29 May 2015

Query Progress Tracking in SQL Server for the DBA VC

This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.

The session covers many techniques for tracking the progress of queries and processes. I also talked about very nice features that were added in SQL Server 2014 and SQL Server 2016.

The… Read more

0 comments, 1,369 reads

Posted in Matan Yungman on 29 May 2015

005 – Antiques Roadshow - WaterOx Consulting

Reading Time: 4 minutes

Are You Running An Antiques Roadshow? In WOxPod!, episode # 005 –...

The post 005 – Antiques Roadshow appeared first on WaterOx Consulting.

Read more

0 comments, 1,068 reads

Posted in WaterOx SQL on 29 May 2015

hey its time for 2016!!!

Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can read books online for it. http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/default.aspx First blog from mobile …..happy leaning…    

Read more

0 comments, 1,185 reads

Posted in Vinay Thakur on 29 May 2015

Detach and Attach All User Databases

Sometimes you are in a scenario where you need to transfer a large number of databases from one server to another. If you decide to perform a detach of all ( or majority) of databases, then the following script can be handy.
Script for Detach Operation 

Read more

0 comments, 968 reads

Posted in SQL and SQL Only on 29 May 2015

Installing SQL Server 2016 CTP2 – UI Changes

SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No, not a Production DB !) and go and get it from here.

This post is based on the UI changes/additions which I observed while I installed this specific… Read more

1 comments, 3,165 reads

Posted in SQLSailor.com on 29 May 2015

Earning my MCSE: Business Intelligence Certification

I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it. Back in May of 2013, I wrote about being Certifiable and wasn’t really interested in pursuing any certifications. What made me change my mind you ask? The short answer is,… Read more

10 comments, 1,470 reads

Posted in SQL Swimmer on 28 May 2015

SQL Server 2008 R2 SP3 Install Errors

Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong.  I would surmise that, in most cases, installing the service pack is a non-event.  No flashing lights, no fireworks, no applause and no major hiccups.  This post is not about one of… Read more

2 comments, 1,989 reads

Posted in John Morehouse | Sqlrus.com on 28 May 2015

Notes on the May 27, 2015 PASS Town Hall

I attended the online Town Hall yesterday, the second one that PASS has held this year. The recording should be available soon (next week) for those that missed it. On to my thoughts:

  • Bravo to PASS for continuing to do this. More communication, more channels, I like the trend.
  • I…

Read more

0 comments, 832 reads

Posted in SQLAndy on 28 May 2015

Creating a SQL 2016 CTP2 Virtual Machine in Azure

With the CTP2 of SQL Server 2016 now released you may be eager to try it out.  One of the best ways to do this in my opinion is to set it up on a virtual machine.  You could certainly do this with VMWare or Hyper-V but my new preference… Read more

6 comments, 2,434 reads

Posted in Devin Knight on 28 May 2015

SQL Server 2016 Live Query Statistics

So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the new features inside SQL Server 2016. You can download SQL Server 2016 CTP2 here: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

While I was playing around with all the new features inside SQL Server 2016 (especially… Read more

0 comments, 3,014 reads

Posted in DotNine SQL Server and more on 28 May 2015

Multiple Windows Groups with different default databases

A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea.

  • UserA is a member of Group1, Group2 and Group3.
  • Group1 is set up as a server principal with a…

Read more

2 comments, 1,809 reads

Posted in SQLStudies on 28 May 2015

Microsoft Azure SQL Databases – Power and Performance

By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to have.
There are three performance levels Basic, Standard and Premium
  • Basic is best suited for a small size database, supporting one single operation at a time such as for…

Read more

0 comments, 993 reads

Posted in The SQL DBA in the UK on 28 May 2015

SQL 2016 Preview has been released!

For those who haven’t noticed already:

SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means it is play time!

You can either download a copy if you’re old school like me, or you can spin up a VM in Azure like all the… Read more

6 comments, 3,235 reads

Posted in Koen Verbeeck on 28 May 2015

Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5

Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account …

Continue reading Read more

0 comments, 923 reads

Posted in Kapil Blogs on 28 May 2015

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015

For those of you who have been following along with this series of posts, I have been looking at how Azure SQL Database Elastic Scale can be used to Horizontally Scale a Payroll…

Read more

0 comments, 3,525 reads

Posted in Pie in the Sky on 28 May 2015

Integrating Other Data Mining Tools with SQL Server, Part 1.1: The Weaknesses of WEKA

By Steve Bolton

…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data Mining and Outlier Detection with SQL Server are in play for this series of occasional articles, which will provide a brief overview of using various third-party data mining… Read more

0 comments, 2,169 reads

Posted in Multidimensional Mayhem on 28 May 2015

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem I’ve had a few times. Getting time slots inside of a period that I want to query. If you have a similar need, or want to learn more, I’d urge… Read more

2 comments, 863 reads

Posted in The Voice of the DBA on 27 May 2015

Older posts