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

Latest Blog Posts

Moving Lookup Data with ReadyRoll

I’ve been using ReadyRoll for a small project and wanted to move some lookup data. There are some tables where I want to keep data in sync across environments, so if my build and release pipeline can do this, great. ReadyRoll makes this easy, and this is a short post… Read more

0 comments, 205 reads

Posted in The Voice of the DBA on 8 February 2018

Settings Goals Professionally

I was reminded of this topic after yesterday’s #SQLChat. Have you set professional goals for yourself? If so, have you set them professionally? What do I mean?

There’s a difference between a wish and a goal. A wish is something we want to happen but we don’t make any effort… Read more

0 comments, 1,567 reads

Posted in Databases – Infrastructure – Security on 8 February 2018

Speaking at PASS.org Summit

For the last 7 years, I have been speaking at the PASS Summit. This event is usually in Seattle, but one year it was in Denver (did not speak at this one) and one year Charlotte, NC. It is hard to explain everything that goes on during that week… Read more

2 comments, 128 reads

Posted in The Smiling DBA on 8 February 2018

Where on Earth is the SQL Server Reporting Services Config Manager?

While we’re on the topic of SQL Server Reporting Services: WHYYYYYY is the Reporting Service Configuration Manager so hard to find from one server to the next? For one thing, it doesn’t help that I’m used to hitting the Windows key and typing “SQL Server” for a list of, oh,… Read more

1 comments, 192 reads

Posted in SQL Awesomesauce on 7 February 2018

“Data Security for the Cloud”: A New Pre-Con at SQLSaturday Chicago

More and more companies are considering a move to the cloud, but one aspect of such a migration that may be overlooked in the transition is the security of the data. In many cases, the cloud provider only handles a portion of the security, leaving you to handle the rest.… Read more

2 comments, 158 reads

Posted in The Data Files on 7 February 2018

Connecting to a SQL Server instance – Back to Basics

Back to the SQL Server Basics with Wayne

Connecting to a SQL Server instance is one of the first things that you will do after installing SQL Server. There are different ways of connecting to the instance. Certain High Availability features offer other ways to connect. In this Back to… Read more

2 comments, 274 reads

Posted in A Discussion of SQL Server-Related Topics on 7 February 2018

Help the fight against cancer

Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community, Tom was a well-known raconteur who wrote around a hundred stories, many of which were published on his blog. He was working on a book containing the best of these… Read more

0 comments, 204 reads

Posted in Born SQL with Randolph West on 7 February 2018

Toolbox - Which Clerk Is Busy?

A few years ago I wrote what would turn out to be my most-hit blog post (so far) titled "Error 701 - Insufficient System Memory - Now what?"

In that post I talk about a troubleshooting scenario that finally led to using DBCC MEMORYSTATUS to find one of…

Read more

0 comments, 119 reads

Posted in Nebraska SQL from @DBA_ANDY on 7 February 2018

UNDERCOVER TOOLBOX: Get Details of All Open Transactions

It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a dream because I was surrounded by drifting clouds, singing angels and hundreds of softly humming SQL Servers where the hardware had been sensibly provisioned and all code carefully optimised) when… Read more

6 comments, 180 reads

Posted in SQL Undercover on 7 February 2018

Backups of backups or How long is my backup really available?

I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, and one of the most complicated. Take a full backup, restore it. Pretty simple right? And yet it’s vital when accident or corruption require recovering data. And as simple as… Read more

1 comments, 1,444 reads

Posted in SQLStudies on 7 February 2018

Azure SQL Database sa Connections?

I was using a query on one of my local SQL Servers where I wanted to know what logins were connected to my databases. I actually ended up running the query against my Azure SQL Database and had some very interesting results.

 SELECT login_name ,COUNT(session_id) AS session_count
FROM sys.dm_exec_sessions
GROUP…

Read more

1 comments, 163 reads

Posted in All About SQL on 7 February 2018

Expanding My Reach

I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted.  Simple- Talk is technical journal and community hub from RedgateIt in I discuss my passion for my work as a Lone DBA.

 

You can find the full article using… Read more

1 comments, 127 reads

Posted in SQLEspresso on 7 February 2018

SQL Server in Kubernetes on Docker for Windows

Last week Docker announced a feature that I’ve been looking forward to for a while: –

And sure enough, when I opened Docker for Windows, there was the update: –

Let’s run through the steps to get this setup. First of all, enable the feature in settings: –

Once installed,… Read more

0 comments, 167 reads

Posted in The DBA Who Came In From The Cold on 7 February 2018

Scale-out SSRS (a brain dump)

So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went well, but there were a couple of hiccups I’d like to record before they fly out of my head again. Note, too, that I am NOT an… Read more

6 comments, 160 reads

Posted in SQL Awesomesauce on 6 February 2018

SQL Server – Internals of sp_spaceused

This article is an effort to dissect the output of the sp_spaceused stored procedure.

Introduction

Understanding the database usage internals and the growth trends play a vital role in the defining the right sizing of the database. sp_spaceused is probably an administrator’s most widely-executed system stored procedure to find the… Read more

0 comments, 192 reads

Posted in PowerSQL By Prashanth Jayaram on 6 February 2018

Power BI Screen Reader Accessibility

I recently wrote a post on the BlueGranite blog called Improving Screen Reader Accessibility in Power BI Reports. It contains some good reasons why accessibility should be considered when it comes to usability features of any web property or data viz. And it shares several tips to make your… Read more

1 comments, 1,447 reads

Posted in Data Savvy on 6 February 2018

tSQLt Course

In the last half of 2017, I decided to run a tSQLt course and went down the route of putting together a free 12-week email course. The intention was that every week students would get a bit of a description about how unit testing T-SQL using tSQLt works and a…

Read more

0 comments, 2,203 reads

Posted in Ed Elliott's Sql Developer Blog on 6 February 2018

Getting Your SET Options

Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options are set for a session. You can check in SSMS, look for defaults, etc., but there’s an easy way.

SELECT @@OPTIONS

This uses the @@options function, which contains a… Read more

3 comments, 1,736 reads

Posted in The Voice of the DBA on 6 February 2018

Conversations with Data Warehouse Experts – Podcast

In this podcast I talk with Mike Rabinovici of Dimodelo Solutions about data being the new currency, the importance of showing customers the art of the possible, and last but not least my go to TV show.  Click here to listen.  Also check out the podcasts of other data… Read more

2 comments, 189 reads

Posted in James Serra's Blog on 6 February 2018

I’m Speaking At SQL Saturday Richmond

I am so excited, I was selected to speak at SQL Saturday Richmond on March 24, 2018, in Richmond, Virginia.

SQL Saturday Richmond has a special place in my heart, it was my very first SQL Saturday as a speaker.  So this will be my second time speaking at this… Read more

0 comments, 108 reads

Posted in SQL Swimmer on 6 February 2018

Newer posts

Older posts