Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Just a week to SQL Saturday in Pensacola

Next week is  SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s free SQL Server training, and a great place to vacation. There are a couple pre-conference sessions available as well if you are looking for some training.


Filed under: Blog Tagged:…

Read more

0 comments, 2 reads

Posted in The Voice of the DBA on 26 May 2016

CPU Scheduling Basics – Windows and SQL Server

In this post we’re going to introduce the basics of CPU scheduling.

In a computer system, only one thing can happen at a time. More specifically, only one task can be on a processor at a point in time. This can expand to several tasks if the system has multiple… Read more

0 comments, 101 reads

Posted in Anthony Nocentino's Blog on 26 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 …

Continue reading Read more

0 comments, 128 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, 98 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

0 comments, 110 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

4 comments, 113 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

1 comments, 83 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

4 comments, 106 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, 126 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, 86 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

0 comments, 86 reads

Posted in PowerSQL By Prashanth Jayaram 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

2 comments, 102 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

1 comments, 81 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

0 comments, 123 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

0 comments, 94 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, 83 reads

Posted in Everyday 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, 194 reads

Posted in Pearl Knows on 24 May 2016

SQL Server – Conditions when value of @@error changes

Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to …

Continue reading Read more

0 comments, 182 reads

Posted in Kapil Blogs on 24 May 2016

PowerShell : Scripting Logins, Role Assignments and Server Permissions Using PowerShell

This post is a continuation of Multiple DB refresh automation using PowerShell post . The OP requested me to automate the login transfer process as well. The script should generate an outfile and execute the file on the target server.

<#
.ProblemStatement

Copying SQL server logins to file is little… Read more

0 comments, 142 reads

Posted in PowerSQL By Prashanth Jayaram on 23 May 2016

The transaction log for database '' is full due to 'AVAILABILITY_REPLICA'. [SQLSTATE 42000] (Error 9002). The step failed. SQL 2014


I have noticed that our SQL jobs are failing due to this error.


Message
Executed as user: ''. The transaction log for database '' is full due to 'AVAILABILITY_REPLICA'. [SQLSTATE 42000] (Error 9002).  The step failed.


Below is the SQL configuration :

SQL version is 2014
One Primary and one…

Read more

0 comments, 116 reads

Posted in SQL Articles by Nani on 23 May 2016

Older posts