Archives: February 2018
Offline installation of SQL Server 2017 on Linux
0 comments, 1,449 reads
Posted in SQLDbaInternals on 28 February 2018
PASS Summit 2018 – Call for Speakers
It is that time again. PASS has opened the Call for Speakers. I have submitted for the past 10 years, and have been selected the past 7 years. This was such an important milestone in my career to be selected and then to present. Making sure I know what… Read more
0 comments, 449 reads
Posted in The Smiling DBA on 28 February 2018
Using the Full Screen Mode in SSMS (Day 33)
Do you ever find yourself working on a query and realize that you need just a bit more real estate in the SSMS window? Or perhaps you find that all the toolbars, menus, etc. are cluttering things up? To solve these issues, you can toggle the full screen mode in… Read more
1 comments, 410 reads
Posted in A Discussion of SQL Server-Related Topics on 28 February 2018
Precons in Richmond, Philadelphia and New York
I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I get the opportunity to do a precon at a SQLSaturday event. Well, I’ve got three coming up.
All three are an all day session entitled “SQL Server Tools for Query… Read more
4 comments, 1,634 reads
Posted in The Scary DBA on 28 February 2018
A day in the life of a Sr DBA/Dev
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points in your career (if not quite daily).
There’s a bug in my code,
Dear Liza, dear Liza,
There’s a bug in my code,
Dear Liza, a bug.
So fix it, Read more
0 comments, 377 reads
Posted in SQLStudies on 28 February 2018
SQL in the City is Live
You can watch on YouTube now: https://www.youtube.com/watch?v=0qyMutBkZsg
If you want slides and notifications, register on the Redgate hub.
We’re recording the sessions and they’ll be available whenever you have time to watch, but join us today. We’re live.
The keynote is done, with more sessions to come today.
0 comments, 816 reads
Posted in The Voice of the DBA on 28 February 2018
A gotcha when switching partitions
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of data from one table to another as a META DATA ONLY operation is absolutely fantastic.
What’s also cool is that we can switch data into a non-partitioned table. Makes life… Read more
1 comments, 3,089 reads
Posted in The DBA Who Came In From The Cold on 28 February 2018
Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds, DATETIME. But let’s say you don’t need that kind of accuracy and are happy with a granularity to the nearest minute. Maybe you’re storing time… Read more
2 comments, 973 reads
Posted in Born SQL with Randolph West on 28 February 2018
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock occurs when one lock causes another process to wait until the current process is entirely done with the resources. Deadlocks Consider the situation where one partially finished transaction must wait… Read more
0 comments, 244 reads
Posted in SQL Treeo on 28 February 2018
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock occurs when one lock causes another process to wait until the current process is entirely done with the resources. Deadlocks Consider the situation where one partially finished transaction must wait… Read more
0 comments, 132 reads
Posted in SQL Treeo on 28 February 2018
Doing DevOPs for your Database? You need to start here…
I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…
In fact it was when I first joined Jade Software that I realised that Ops and DEV had a common interest in making systems go. In 2002 I started working… Read more
6 comments, 1,200 reads
Posted in The Hybrid DBA's Blog on 28 February 2018
New Built-in Function STRING_AGG() – SQL Server 2017
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am going to discuss one of the built-in aggregate functions – “STRING_AGG()”.
The function concatenates values from rows as one value with a separator, and the main advantage is it… Read more
2 comments, 8,203 reads
Posted in SQL Geek on 28 February 2018
Typing Alternative Characters
I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one language and most of my work has been with US centric industries. I’ve rarely had the need to deal with Unicode and most of my databases have used varchar() everywhere.… Read more
1 comments, 441 reads
Posted in The Voice of the DBA on 27 February 2018
Adaptive Joins
I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So, I figured I could do a quick overview.
Adaptive Join Behavior
Currently the adaptive join only works with columnstore indexes, but according to Microsoft, at some point, they will also… Read more
3 comments, 1,084 reads
Posted in The Scary DBA on 27 February 2018
How to make a Database Request
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is slow. I’m going to let you in on the secret of the best method to get what you want out of your DBA. Ready? Here’s the secret… Ask… Read more
1 comments, 439 reads
Posted in SQL Awesomesauce on 27 February 2018
Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!
Planning to Increase Cost Threshold for Parallelism
8 comments, 1,047 reads
Posted in Eitan Blumin on 27 February 2018
Productivity For The Data Pro
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate within the traditional 9-5 office job but the nature of working around databases requires flexibility; and, the focus is shifting constantly minute by minute. One moment you’re looking at something… Read more
0 comments, 420 reads
Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 27 February 2018
Splitting It Up: Side by Side Queries In SSMS
There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc…
If using two monitors you can have a query window on each as a reference, or you can resize two query window tabs so… Read more
0 comments, 251 reads
Posted in Bert Wagner on 27 February 2018
What Do Read Counts On Your SQL Server Execution Plans Even Mean?
If you’ve ever spent any time looking at execution plans you will have almost definitely noticed all the read counts on the different operators, you’ve probably already realised lower reads is best as that equates to less time reading disks. Have you ever wondered what the number actually means though?… Read more
0 comments, 59 reads
Posted in Gavin Draper's SQL Server Blog on 27 February 2018
Who installed SQL Server?
Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent requirement to patch the physical box from Windows team.
As the server was not in production, so the server entry was missing. Since Windows team wanted to take action on… Read more
2 comments, 2,635 reads
Posted in SQL Geek on 27 February 2018