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

Latest Blog Posts

SQLSaturday Orlando 2017 Notes – Part 3

This year we held our fourth Student to IT Pro Seminar for the students at Seminole State College. It runs from 9 am to 1130, concurrent with SQLSaturday but in a different building. Here is the schedule from this year:

Time Description
 8:30 to 9:00  Check-in & Informal Networking

Read more

0 comments, 63 reads

Posted in SQLAndy on 22 October 2017

SQLSaturday Orlando 2017 Notes – Part 2

SQLSaturday is really three sites. The public facing one (www) plus one for event admins and one for HQ to do overall admin. Most of the notes in this post apply to the site for event admins. These are all from my perspective which is biased in a few ways;… Read more

0 comments, 69 reads

Posted in SQLAndy on 22 October 2017

A virtualized CPU forced me to eat my lunch early, every day, for weeks

I worked one particular contract where I was forced to take my lunch at 11:35 every day, and it was all virtualisations fault!

To set the scene it was a company who wasn't really used to having developers, they had a load of SQL analysts and some mainframe developers but…

Read more

0 comments, 141 reads

Posted in Ed Elliott's Sql Developer Blog on 21 October 2017

SQL Server on Linux Content at PASS Summit

PASS Summit is right around the corner and I’ll be there speaking on Monitoring Linux Performance for the SQL Server Admin!

There’s a fantastic amount of SQL Server on Linux content available at Summit. I encourage you to attend one of these sessions. You’ll likely find me at all… Read more

0 comments, 174 reads

Posted in Anthony Nocentino's Blog on 20 October 2017

SQL Server on Linux – External Memory Pressure

In this blog post we’re going to explore how SQL Server on Linux responds to external memory pressure. On Windows based SQL Server systems we’ve become accustomed to the OS signaling to SQL Server that there’s a memory shortage. When signaled, SQL Server will kindly start shrinking it’s memory caches,… Read more

0 comments, 350 reads

Posted in Anthony Nocentino's Blog on 20 October 2017

Error Installing SQL Server 2017

A quick blog post on an error I got when installing SQL Server 2017 RTM. I ran the set-up for the usual features (database engine, SSAS, SSIS, SSRS and MDS), but the installation failed for the database engine and SSIS. During the set-up, I received two pop-ups notifying that something… Read more

1 comments, 110 reads

Posted in Koen Verbeeck on 20 October 2017

Seattle SQL Pro Workshop 2017

Seattle SQL Pro Workshop 2017

October is a great time of year for the SQL Server and Data professional. There are several conferences but the biggest happens to be in the Emerald City – Seattle

Some friends and I have come together the past few years to put on… Read more

0 comments, 218 reads

Posted in SQL RNNR on 19 October 2017

Let Her Finish: Voices from the Data Platform

This year I had the pleasure of contributing a chapter to a book along with some very special and talented people. That book has now been released and is available on Amazon!  Both a digital and print version are available. My chapter is about data viz in Power BI,… Read more

0 comments, 196 reads

Posted in Data Savvy on 19 October 2017

Where do you install tSQLt?

The question of where to install tSQLt is probably the most common question I get when I talk about unit testing T-SQL, so much so that I thought that it would be a good topic for a blog. I mention tSQLt in the title, but this covers all unit test…

Read more

0 comments, 241 reads

Posted in Ed Elliott's Sql Developer Blog on 19 October 2017

SQL Data Generator–Getting a value based on another column

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today.

One of the things that people often want to… Read more

0 comments, 305 reads

Posted in The Voice of the DBA on 19 October 2017

Connecting to Azure SQL Database Primary Endpoint – Failover Groups

When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint via SSMS (SQL Server Management Studio) is pretty simple, if you remember one little thing, which will be the discussion point for this blog post.

I wrote about Failover… Read more

0 comments, 124 reads

Posted in All About SQL on 19 October 2017

Introducing XESmartTarget

Three years ago, I started to work on a project called ExtendedTsqlCollector. I blogged about it multiple times here on spaghettidba.com.

Even if I received positive feedback, I knew that one aspect was slowing down the adoption of the project: the Data Collector. That particular feature of SQL… Read more

1 comments, 100 reads

Posted in SpaghettiDBA on 19 October 2017

SQLSaturday Orlando 2017 Notes – Part 1

Part 1 will be about things we did (or didn’t) do and some lessons learned. In Part 2 I will share some thoughts on the SQLSaturday tools/web site. Part 3 isn’t really about SQLSaturday, rather our student seminar that we run concurrently. I’ll get to Part 2 and 3 as… Read more

0 comments, 120 reads

Posted in SQLAndy on 19 October 2017

Don’t “Test” Against Production

A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the exercise was discussing some scans to run. However, before we did anything, he made sure to state that we should run against a non-production environment first. Apparently, some of his… Read more

0 comments, 114 reads

Posted in Databases – Infrastructure – Security on 18 October 2017

Rebooting Ubuntu Linux from the Command Line–#SQLNewBlogger

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

Since SQL Server 2017 is now out, and Linux is an option, I thought I’d write a bit more about little Linux things that admins might want to… Read more

0 comments, 187 reads

Posted in The Voice of the DBA on 18 October 2017

The perils of RAID

Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced physical hard drive failure. I asked a lot of questions about the configuration of the data layer, and it came to light that it was a fairly regular setup. SQL… Read more

0 comments, 264 reads

Posted in Born SQL with Randolph West on 18 October 2017

Does Your Code Have a Preamble?

Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a block of code I refer to as a preamble. If yours doesn’t I strongly recommend you start adding it. It drives me crazy when I see code with no documentation… Read more

1 comments, 124 reads

Posted in SQLEspresso on 18 October 2017

And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!

We all get them at one point or another - deadlocks.

I have Object 1 and need Object 2, you have Object 2 and need Object 1:

This isn't the same as simple blocking, where I have Object 1 and you want it (but you can't have it…

Read more

0 comments, 155 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 October 2017

Updateable CTEs

CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t overly well known is that you can actually update the data within the CTE. No, I don’t mean using using the UPDATE statement with a CTE but actually running the… Read more

3 comments, 672 reads

Posted in SQLStudies on 18 October 2017

Are your disks formatted with UseLargeFRS?

PureStorage has a pretty cool post that mentions the importance of formatting SQL Server disks with a 64KB clusters and the /L flag (also known as the UseLargeFRS switch on PowerShell's Format-Volume cmdlet).

Why UseLargeFRS? It's to help avoid DBCC CHECKDB failures on large/busy databases. But how do you… Read more

0 comments, 292 reads

Posted in Cody Konior on 18 October 2017

Older posts