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

Latest Blog Posts

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, 42 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, 56 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, 96 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, 63 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, 58 reads

Posted in SQLEspresso on 18 October 2017

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

https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpg
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:

https://i-technet.sec.s-msft.com/dynimg/IC4289.gif
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, 87 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

0 comments, 72 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, 139 reads

Posted in Cody Konior on 18 October 2017

Linked Servers and Stats

Linked Servers

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers. Unfortunately, some are of the belief that a linked server is the solution to… Read more

0 comments, 104 reads

Posted in SQL RNNR on 17 October 2017

Automating Everything with PowerShell – Getting Started #tsql2sday

I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other product with active support in PowerShell, I try to write scripts to do everything. I believe in the old proviso that good engineers are lazy engineers (thank you, Andy Leonard Read more

0 comments, 75 reads

Posted in Databases – Infrastructure – Security on 17 October 2017

Bug with STATISTICS TIME?

I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able to measure improvements when performance tuning (Measuring SQL Query Performance).

You have to be a little bit wary though, there are a few places where they don’t report… Read more

0 comments, 87 reads

Posted in Matthew McGiffen DBA on 17 October 2017

Quick SQL Prompt Updates in a Pattern

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it a try.

We had a customer post a question today… Read more

0 comments, 140 reads

Posted in The Voice of the DBA on 17 October 2017

Microsoft Ignite Big Data Presentations

There were so many good presentations at Microsoft Ignite, all of which can be viewed on-demand.  I wanted to list the big data related presentations that I found the most useful.  It’s a lot of stuff to watch and with our busy schedules can be quite challenging to view… Read more

0 comments, 279 reads

Posted in James Serra's Blog on 17 October 2017

Monitoring SQL Server database status changes using T-SQL and PowerShell scripts

Monitoring a SQL Server database is a critical component of database administration. Ninety percent of the organizations expect the number of databases to increase over the next twelve months. An increase in data volumes can have negative effects on the availability of databases. Hence, SQL Server database monitoring is considered… Read more

0 comments, 133 reads

Posted in PowerSQL By Prashanth Jayaram on 17 October 2017

Performing in-database predictions in SQL Server 2016 & 2017

Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and statistical analysis inside their database engine. In SQL Server 2016 Microsoft introduced the integration of the R language and in SQL Server 2017 Python was added.

Both these languages give… Read more

0 comments, 179 reads

Posted in DotNine SQL Server and more on 17 October 2017

All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters

As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist in the following question on DBA.StackExchange:

SELECT query: filter unable to distinguish between two different characters

I ran into what initially looked to be an unfortunate situation. I… Read more

1 comments, 107 reads

Posted in SQL Quantum Leap on 16 October 2017

Power BI Custom Visuals Class (Module 73 – Heat Streams)

In this module you will learn how to use the Heat Streams Custom Visual.  The Heat Streams visual allows you to visualize and compare a categorical value over time.

Module 73 – Heat Streams

Downloads

Read more

1 comments, 135 reads

Posted in Devin Knight on 16 October 2017

Speaking at IT/Dev Connections 2017 – San Francisco!

I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my second year at IT/Dev Connections, real content for IT pros!

Networking Internals for the SQL Server Professional

Tuesday, 10/24/2017: 1:15 pm – 2:30 pm

Room: Contiental 7

Abstract

Once data… Read more

0 comments, 126 reads

Posted in Anthony Nocentino's Blog on 16 October 2017

Database Fundamentals #14: Modifying Data Through SSMS

I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data manipulation is not the preferred mechanism. T-SQL is the right way to manipulate the data in your database. For purposes of completion though, I will show the GUI methods in… Read more

1 comments, 100 reads

Posted in The Scary DBA on 16 October 2017

Feeling Stunned

If you work in the Microsoft technology space you are probably aware of the mass of people who refresh their inboxes like a mad man on the first of the month.  It used to be on the first of every quarter but that has since changed.  I’ll admit that I… Read more

8 comments, 109 reads

Posted in John Morehouse | Sqlrus.com on 16 October 2017

Older posts