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

Latest Blog Posts

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, 96 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, 89 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, 71 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, 49 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, 47 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, 45 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, 80 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, 74 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, 61 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, 46 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 May 2016

Which method is best to import data from Oracle database to SQL

Hi Guys,

I would like to start a discussion through my blog to know more about this topic.

Below options I know to import data from Oracle to SQL..

1) Import/Export
2) Linked Server (Using OpenQuery)
3) SSIS Packages

The fastest among these 3 I noticed is the 3rd one…

Read more

0 comments, 128 reads

Posted in SQL Articles by Nani on 22 May 2016

Identity increment is jumping in SQL Server database


Please look at the below screenshot to understand what jumping of identity value is (It is taken from SQL 2014 Database table.)

Observe records below the red line..the identity value jumped from 17 to 1014 and started continuing from there.

Cause: This is not actually the issue or bug. It…

Read more

2 comments, 153 reads

Posted in SQL Articles by Nani on 20 May 2016

SQL Server Random Workload Generator

Hello Dear Reader!  Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog).  He’s an Microsoft Data Platform MVP, MCM,  part of the amazing crew over at SQLSkills, and a really nice guy.  

About 4 years ago Jonathan created The AdventureWorks2008R2…

Read more

0 comments, 169 reads

Posted in SQLBalls on 20 May 2016

SQL Server Exercise for Data Warehouse Candidates

Background

Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire competent and reliable people. We recently had to fill a data warehouse position in our team and I setup the following technical exercise that helps measure technical competencies… Read more

0 comments, 184 reads

Posted in Select SIFISO Blogs on 20 May 2016

SQLSaturday Pensacola Up Next For Me, Baton Rouge on the Horizon

Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been in the past a pilgrimage that the wife and I enjoyed in early June, and we'll both be there again now that the event is returned for the first…

Read more

0 comments, 125 reads

Posted in SQL Tact on 20 May 2016

Bad Data Can Kill

Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business, where estimates of total losses are usually gauged in the hundreds of billions of dollars per year. Nor am I talking about the inconvenience we all face when presented with… Read more

0 comments, 162 reads

Posted in Tim Mitchell on 20 May 2016

SSRS 2005 Bug - Percentage calculated column when Exporting to Excel

Nature of the Issue Faced :- Say you have 3 columns in a tablix/table on the report. There are 3 textboxes in each of these columns. Let us give them names as textbox1, textbox2 and textbox3.
Textbox3 should be textbox1 - textbox2. We are using following formula to achieve this…

Read more

0 comments, 89 reads

Posted in EVERYDAY MSBI/SQL CHALLENGES on 20 May 2016

Speaking about Power BI @ ITPROceed 2016

I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this event, it’s an IT Pro focused event in Belgium about Microsoft Technologies. And what’s even better, it’s totally free.

My session will be a general overview of what you… Read more

0 comments, 140 reads

Posted in Koen Verbeeck on 19 May 2016

StorSimple Appliance – Part 1 Overview

Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance (which you can find here and here). I notice some others are looking at the same and would like to share more information on this device and the test…

Read more

0 comments, 382 reads

Posted in Dennis's SQL Blog on 19 May 2016

Changing a Computed Column–#SQLNewBlogger

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

I was working with a computed column the other day, and realized I had the wrong definition. In this case, I was performing some large calculation, and… Read more

0 comments, 212 reads

Posted in The Voice of the DBA on 19 May 2016

Older posts