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

Archives: May 2016

SQL Server – Rollback transaction completely in case of error

Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback if we use multiple insert statement in transaction. Let me give you a demo on this how to handle such situation. Create table Test_tran (               ID Int Primary… Continue reading…

Read more

0 comments, 500 reads

Posted in Kapil Blogs on 26 May 2016

The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query.

There can be a few reasons for this error:

  1. The remote computer is blocked by the firewall.
    Solution: Open the Group Policy Object Editor snap-in (gpedit.msc) to edit the Group Policy…

Read more

0 comments, 588 reads

Posted in PowerSQL By Prashanth Jayaram on 25 May 2016

Azure Storage pricing

Azure storage is a great, inexpensive solution for storing your data in the cloud.  There are many types of Azure storage options, but I wanted to list here the pricing of the most common type: block blob.

The pricing below is based on the East US region (most other… Read more

1 comments, 591 reads

Posted in James Serra's Blog on 25 May 2016

A Basic Recursive CTE and a Money Lesson

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

When I was a six or seven year old, my Mom asked me a question. She asked if I’d rather have $1,000,000 at the end of the… Read more

8 comments, 521 reads

Posted in The Voice of the DBA on 25 May 2016

Connecting to Azure SQL Database

Recently I created my first Azure SQL Database. But now I need to connect to it.

You can connect using any number of tools. We can actually see several options by going back to our Azure Portal. Select the SQL Databases list, a specific SQL Database, and then… Read more

2 comments, 359 reads

Posted in SQLStudies on 25 May 2016

A Moment For Reflection…

While this is a personal blog, I try to keep it focused on either technical topics or personal development and leadership related to technical topics. This post is a complete deviation from all of the above. Please, read it anyway.

I went to Auschwitz and Birkenau.

Words are failing me… Read more

8 comments, 348 reads

Posted in The Scary DBA on 25 May 2016

Changing Your PASS Credentials

I got an email today from PASS, noting that credentials were changing from username to email. That’s fine. I don’t really care, but I know I got multiple emails to different accounts, so which account is associated with which email?

I clicked the “login details” link in the email and… Read more

2 comments, 400 reads

Posted in The Voice of the DBA on 24 May 2016

Some Pester Tests for SQL Defaults

When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the slides and code here) I found out about Irwin Strachans Active Directory Operations Test which got me thinking.

I decided to do the same for my usual SQL… Read more

0 comments, 440 reads

Posted in SQL DBA With A Beard on 24 May 2016

XML-> JSON document Example

Convert the XML document to JSON document example

<person>
  <name>John</name>
  <age>25</age>
  <address>
    <city>New York</city>
    <postalCode>10021</postalCode>
  </address>
  <phones>
    <phone type="home">212-555-1234</phone>
    <phone type="mobile">646-555-1234</phone>
  </phones>
</person>

 

{
“name” : “John”,
“age” : 25,
“address” : { “city” : “New York”, “postalCode” : “10021” },
“phones” :
[
{“phone”:”212-555-1234″, “type” : “home”},
{“phone”:”646-555-1234″,… Read more

1 comments, 316 reads

Posted in PowerSQL By Prashanth Jayaram on 24 May 2016

SSMS new feature - Live execution plans

SQL Server 2016 brings one of the new features - The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar.
Then you have a live flow of the execution plan.

Read more

0 comments, 106 reads

Posted in SQL Mighty on 24 May 2016

SSMS 2016 installation - The new SQL Server Management Studio 2016

This spackle hints toward installation of the SQL Server 2016 SSMS. The installation of SSMS 2016 is different and it's a separate installation. It's not a part of the SQL Server installation as it was the case until SQL Server 2014.
The link from the window below forwards you to…

Read more

0 comments, 225 reads

Posted in SQL Mighty on 24 May 2016

On the Buckeye Blitz!

In just a few weeks I’ll be doing the Buckeye Blitz. That is, a tour of user groups in Ohio (aka, the Buckeye state, after a tree, not a sports team), one per day across a week. Here’s how it breaks down:

Cleveland: 6/13
Toledo: 6/14
Columbus: 6/15
Cincinnati:… Read more

3 comments, 386 reads

Posted in The Scary DBA on 24 May 2016

SQL Server 2016 features: R services

One of the more interesting features in SQL 2016 is the integration of the R language.

For those who haven’t seen it before, R is a statistical and data analysis language. It’s been around for ages, and has become popular in recent years.

R looks something like this (and I… Read more

2 comments, 461 reads

Posted in SQL In The Wild on 24 May 2016

SQL Server 2016 features: R services

One of the more interesting features in SQL 2016 is the integration of the R language.

For those who haven’t seen it before, R is a statistical and data analysis language. It’s been around for ages, and has become popular in recent years.

R looks something like this (and I… Read more

2 comments, 33 reads

Posted in SQL In The Wild on 24 May 2016

SQL Server Service Broker – Internal Activation

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.

Previous posts:

Read more

1 comments, 419 reads

Posted in Cleveland DBA on 24 May 2016

Reblog: Unexpected result with the File System Task

SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default value, so this still applies.

Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services.… Read more

2 comments, 1,010 reads

Posted in Koen Verbeeck on 24 May 2016

Database Restore Fails with Msg 3154

Have you ever tried to restore over an existing database only to receive the following error message?

Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'AdventureWorks2012' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE…

Read more

0 comments, 376 reads

Posted in Everyday SQL on 24 May 2016

The new SQL Server Management Studio 2016

The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014.

The link from the window below forwards you to the newest release which you can download and install.

The installation progress… Read more

0 comments, 42 reads

Posted in Si vis pacem, para sql on 24 May 2016

Live execution plans

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar.

Then running a query is shown with a live flow of the execution plan like below

You can watch the progress of the execution in the… Read more

0 comments, 41 reads

Posted in Si vis pacem, para sql on 24 May 2016

SQL Server 2016 NYC Launch Event - Tickets Running Out!

In a previous blog, I spoke about the upcoming RTM Launch of SQL Server 2016 - Get Ready! Microsoft is ready to rock-and-roll and rtm its highly anticipated SQL Server 2016 data platform in 1-week!
Strategically and lucky stars aligned planning, June 2, 2016 will be the NYC Big Apple… Read more

0 comments, 910 reads

Posted in Pearl Knows on 24 May 2016

Newer posts

Older posts