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

Latest Blog Posts

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,571 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, 171 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, 135 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, 194 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, 171 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, 199 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,491 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,522 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,847 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, 235 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, 110 reads

Posted in SQL Swimmer on 6 February 2018

Lessons Learned From SQL Saturday Cleveland

I can finally breath a sigh of relief, my first time of presenting two sessions back to back is finally over.  I was so honored to have been chosen to speak at SQL Saturday Cleveland on February 3, 2018.  When I got the email notifying me of my selection, I… Read more

0 comments, 105 reads

Posted in SQL Swimmer on 6 February 2018

Waiting Tasks Reveal Pain Points

Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I didn’t have to go beyond identifying the waiting tasks to quickly troubleshoot a production performance issue.

I have encountered a case where an application filter got stuck in loading… Read more

0 comments, 1,755 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 February 2018

Bug in SSMS V17.4

 

If you are using SSMS V17.4 as I am

You may encounter a weird error. This can be repeated as follows:

Open a new SSMS window, and connect to any SQL Server instance (I tested on connections to SQL Server 2012/2014/2016/2017), and then execute the following

set showplan_all on; Read more

0 comments, 128 reads

Posted in DBA Philosophy on 6 February 2018

Learning Goals–January Review

In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks out of the country and then a relaxing holiday season. Actually, holidays extended slightly with a ski trip and a wedding in January.

This is a look back at… Read more

0 comments, 232 reads

Posted in The Voice of the DBA on 5 February 2018

Wait Statistics on a Query

Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be done through a variety of mechanisms from sys.dm_os_wait_stats (use this query for that) to sys.dm_db_wait_stats in Azure SQL Database. Those cover the system and the database, however, what about capturing… Read more

0 comments, 2,182 reads

Posted in The Scary DBA on 5 February 2018

SQL Homework – February 2018 – Work with security

This month let’s create some security!

  • Create logins: GUI 5 pts/Script 5 pts
    Create a SQL login and a Windows authenticated login. Make sure you can connect to the instance with each. It’s best if you understand the difference.
  • Create users: GUI 5 pts/Script 5 pts
    In a user database…

Read more

0 comments, 146 reads

Posted in SQLStudies on 5 February 2018

Forensic Analysis of Log files in SQL Server

The Importance of Log Files in SQL Server

On the SQL server every day we perform many transactions and as we know that all these transactions affect the log file. After all, the transactions are stored in the log file so every transaction contains some space in the log file… Read more

0 comments, 198 reads

Posted in SQL Server Overview on 5 February 2018

Giving back – Speaking Mentors

I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who are all experts in their respective fields.

They have (almost literally) dragged me into at first blogging, and then eventually speaking. I could not have done any of it without… Read more

0 comments, 169 reads

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

Power BI with Azure Data Lake - where the water doesn't run dry

(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in Power BI, where the main file was slightly above 600 MB - http://datanrg.blogspot.com/2018/01/when-its-cold-outside-perhaps-power-bi.html. Not a big deal when you have only a few such data files that you can directly be…

Read more

0 comments, 220 reads

Posted in Data Adventures on 4 February 2018

Newer posts

Older posts