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

Latest Blog Posts

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

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

1 comments, 92 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, 50 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, 54 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, 82 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

0 comments, 53 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, 85 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, 74 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, 60 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, 146 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, 152 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, 115 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, 102 reads

Posted in SQL Articles by Nani on 23 May 2016

SQL Server on VMware Workshop at VMworld

I am extremely proud to announce my participation in the inaugural SQL Server workshop at this year’s VMworld US in Last Vegas on August 27th. If your SQL Servers are running in a VMware environment, this course is critical to your success!

The first business critical applications and databases… Read more

0 comments, 64 reads

Posted in Technobabble by Klee from @kleegeek on 23 May 2016

Monday Morning SQL Break – May 23, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

0 comments, 72 reads

Posted in StrateSQL on 23 May 2016

Monday Morning SQL Break – May 16, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

0 comments, 65 reads

Posted in StrateSQL on 23 May 2016

PASS Board 2016: Update #3

I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question the Board needs to act on.

Here’s what I’ve been up to.

First, based on your feedback (thanks) and conversations that I’ve had with members of the Board, I’m… Read more

0 comments, 93 reads

Posted in The Scary DBA on 23 May 2016

Master_Views: master_objects, master_tables, etc

There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of all files from all databases. It’s been somewhat frustrating to me that there is no similar master_objects, master_tables, master_indexes etc. So what does a dev/dba do? Create them! So… Read more

0 comments, 85 reads

Posted in SQLStudies on 23 May 2016

The Road to SQLSaturday Orlando – 2016

This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress report.

  • Requesting the event # is much better than the last time I did it (years ago). More of a wizard, lets you set the exact location (though it’s a…

Read more

0 comments, 75 reads

Posted in SQLAndy on 23 May 2016

How Do I Change My Domain Password on Windows Server 2012?

As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers on client domains.  Most clients (unfortunately not all of them - security is important, people!) have some variant of password expiration in their domains requiring regular password changes every 30/90/180…

Read more

0 comments, 70 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 May 2016

Older posts