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

Latest Blog Posts

Azure: What’s the difference between SQL Database and SQL Server?

If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each month (or possibly a bit earlier as in this case) someone presents a blogging idea. Everyone who wants to participate then comes up with something on that subject and posts… Read more

1 comments, 128 reads

Posted in SQLStudies on 9 August 2016

SQL UG Leaders: Reach Out to Your .NET Friends

In Baton Rouge we make no secret that our user groups and our 578-person SQLSaturday combines the volunteers and attendees of our local PASS chapter with our neighborly Baton Rouge .NET User Group. It's not just SQL folks attending our monthly meetings and annual event.

When discussing this, I've…

Read more

0 comments, 220 reads

Posted in SQL Tact on 9 August 2016

Great Value IT Training 9th August – Automate with PowerShell

It’s that time of the week when the Great Value IT training page gets its weekly update and this week there are some great courses on offer.

One course that  I would like to draw you attention to is 969 Windows PowerShellAutomating Administrative tasks. PowerShell is undoubtedly a very…

Read more

0 comments, 129 reads

Posted in The SQL DBA in the UK on 9 August 2016

TOMORROW: CNJSSUG Presents - Hilary Cotter - Performance Tuning

Wednesday, August 10, 2016, The next meeting of the Central NJ SQL Server Users Group will be on Wednesday August 10, 2016 at 6pm, located at In-Person @ 101 Wood Avenue South, Suite 900 Iselin, New Jersey, United States (map).  Long time SQL Server MVP, Hilary Cotter, will… Read more

0 comments, 171 reads

Posted in Pearl Knows on 9 August 2016

Disk Space GUI Tool – Multi Server(s) – Grid and Email Output

Monitoring server resources is critical and important job of any Administrator. Keeping things organized might improve application availability and server availability. Being a database administrator for 1o years have faced and handled/managed lot of issues with disk space. There are many times we end up with I/O bottleneck and disk… Read more

0 comments, 138 reads

Posted in PowerSQL By Prashanth Jayaram on 8 August 2016

SQL Saturday Minnesota Precon – The Complete Primer to Infrastructure Tuning

I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Minnesota on Friday, September 30 called ‘The Complete Primer to SQL Server Infrastructure Tuning‘.

The focus of the course is to help those new to the enterprise… Read more

0 comments, 75 reads

Posted in Technobabble by Klee from @kleegeek on 8 August 2016

Slash star, dash dash: Be obsessive about comments

I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the reasons why I’m writing and presenting an hour long session on /* */ and — a bit later, but first: Why am I calling comments a “hidden support feature”? Comments…

Read more

12 comments, 1,432 reads

Posted in SQL Awesomesauce on 8 August 2016

SQL Saturday and the Alamo

I’ll be traveling this week to SQL Saturday #550 in San Antonio. This is my first time traveling to this part of Texas and I’m looking forward to getting a few minutes to swing by The Alamo and see a piece of history. The Riverwalk is also on my… Read more

0 comments, 135 reads

Posted in The Voice of the DBA on 8 August 2016

Audit All Select Statements

Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required that queries be audited and tracked to reach compliance with the legislation or regulation. To achieve this compliance, this article will demonstrate how to use Extended Events to audit statements… Read more

4 comments, 1,844 reads

Posted in SQL RNNR on 8 August 2016

Top 5 books on Enterprise Architecture

My post the top 3 books for becoming TOGAF certified punlished   last week looked at books on preparing for the TOGAF certification. Those books were specific to passing the TOGAF exams. 
What if you wanted to learn about Enterprise Architecture without the focus being on passing a certification exam? 

I…

Read more

0 comments, 130 reads

Posted in The SQL DBA in the UK on 8 August 2016

Current Running Queries

Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my first line of defense in any performance monitoring problem and has helped me narrow down most of the performance issues.

Many moons ago, I had posted a similar script over…

Read more

0 comments, 2,051 reads

Posted in SQL and SQL Only on 7 August 2016

Create a Date Dimension in Azure SQL Data Warehouse

Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building data warehouses in SQL Server for a while have collected our favorite scripts to build out a date dimension. For a standard date dimension, I am a fan of Aaron… Read more

0 comments, 907 reads

Posted in Data Savvy on 6 August 2016

AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING

AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING

 

I have recently come across an issue that, one of my alwaysON secondary replica databases are went into “NOT SYNCHRONIZED and RECOVERY PENDING” state. It is a geo cluster alwaysON with 4+2 nodes configured in both synchronous and asynchronous mode. 

The issue… Read more

0 comments, 1,204 reads

Posted in SQL Server Blog Forum on 6 August 2016

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news. In our quest to improve security we seemingly always find more and more products that are supposed to help with that security. Sometimes, those products require a data… Read more

4 comments, 265 reads

Posted in SQL RNNR on 5 August 2016

What is the Lambda Architecture?

Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and stream-processing methods.  This idea is to balance latency, throughput, scaling, and fault-tolerance by using batch processing to provide comprehensive and accurate views of batch data, while simultaneously using real-time… Read more

2 comments, 1,977 reads

Posted in James Serra's Blog on 5 August 2016

Visual Studio Live!–Washington DC–Save with me

I’m going to be speaking this fall at Visual Studio Live, Washington D.C. edition on Oct 3-6. This is my first time attending the event, and I’m looking forward to speaking in DC.

This is a three day conference, with a day of pre-cons, and if you’re on the East… Read more

2 comments, 147 reads

Posted in The Voice of the DBA on 5 August 2016

Dropping Masking from a Column–#SQLNewBlogger

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

This is a quick one. As I experimented with Dynamic Data Masking for the Stairway to Dynamic Data Masking, and writing my Using SQL Compare with… Read more

0 comments, 763 reads

Posted in The Voice of the DBA on 4 August 2016

AlwaysON move database without breaking HADR

Move database without breaking alwaysON

 

This post is going to show the database movement from one drive to another drive, without breaking the database from alwaysON configuration. An application has created the many databases to both primary and secondary replica servers to the default location of C drive.

There are… Read more

6 comments, 1,371 reads

Posted in SQL Server Blog Forum on 3 August 2016

Dreaming of SQL Saturday

I’m truly stunned at the responses I received to my post asking how far people have traveled for a SQL Saturday. I posted here, and at SQLServerCentral. In addition, I got plenty of emails from people, detailing their travels.

Early warning, this gets a little long.

I am…

Read more

10 comments, 1,007 reads

Posted in The Voice of the DBA on 3 August 2016

What’s the difference between LEFT and RIGHT OUTER JOINs?

A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?”

There are several different kinds of JOINs. OUTER JOINs are one of the more complex options. With an INNER JOIN only those rows that have a match on both sides of the… Read more

0 comments, 829 reads

Posted in SQLStudies on 3 August 2016

Newer posts

Older posts