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

Archives: February 2017

How many Backups is Too Many?

Does this title seem strange?  Of course we know this is the true answer:


But here is a story of a client that may have too many backups after all.


Our monitoring system found that the backups on a client server had suddenly started running very long.  When…

Read more

4 comments, 2,409 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 February 2017

Friday Reading 2017-02-24

Wow that week absolutely flew by! Here’s what I’ve been reading…

Seatbelt learning with Uncle Buck
Buck Woody goes through how he learns on the move (great article)

Hardware selection for a home lab – Part 1
Glen Berry goes through using the Intel NUC series for a home lab… Read more

0 comments, 278 reads

Posted in The DBA Who Came In From The Cold on 24 February 2017

Upgrading SQL Server on Linux

I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot of time to work on the Linux version lately, but I thought I’d try and see how well the upgrade went.

There’s an install and upgrade page at Microsoft you… Read more

1 comments, 2,628 reads

Posted in The Voice of the DBA on 23 February 2017

Confusion of An Old Technologist

As someone who still actively pursues a career in technology, I’m a little on the older side. I got started in tech when a lot of the people I know were still in elementary school. So please understand that when I write the rest of this little… rant.

I read… Read more

10 comments, 329 reads

Posted in The Scary DBA on 23 February 2017

Better SQL Agent Job Alerts

  They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us when a job fails or succeeds, but if you have ever looked at the message, there isn’t much detail in it. Take a look at this (slightly edited) email… Read more

15 comments, 3,260 reads

Posted in WaterOx SQL on 23 February 2017

Database Security Webinar Today (Feb 23)

Today at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server.

Register Here for Free (you can also register for other upcoming MSSQLTips webinars)

Here’s what I’ll be covering:

You’re building a new application using SQL Server as a back-end and you… Read more

0 comments, 387 reads

Posted in Databases – Infrastructure – Security on 23 February 2017

Digital Privacy is the Wild West

Who has the legal right to access your personal and private digital assets? The answer can be complex, and will depend on where you live, where you are traveling from and to, and whether or not you’ve been suspected of a crime. The rules governing personal digital access are evolving… Read more

4 comments, 1,395 reads

Posted in Tim Mitchell on 23 February 2017

Upcoming PASS Events

There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me but marketing is something I am not into…yet!!!

The one thing I do like is the formatting when viewing on a mobile device. That is very nice. Here is what… Read more

0 comments, 399 reads

Posted in The Smiling DBA on 23 February 2017

SQL Server 2016: The Coolest New Feature – Live Query Stats

This is the first in a series of blog posts about how great SQL Server 2016 is, and why you should all want to upgrade your applications to this platform.

I’ll be honest with you, I’m not usually a person to be bothered about new versions, about being up there… Read more

1 comments, 769 reads

Posted in Matthew McGiffen DBA on 23 February 2017

Webinar- SQL Server 2016 - Always Encrypted / Security

Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM

SQL Server has had ways to encrypt data in the past - for example, Transparent Data Encryption (TDE). This technology protects the data at rest and when the database files or backups are…

Read more

1 comments, 541 reads

Posted in Ganapathi's MSSQLLover on 23 February 2017

Azure Cognitive Services Text Analytics – An API Calling Application

[read this post on Mr. Fox SQL blog]

Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in the Gold Coast on Azure Cognitive Services – and we had an absolute blast of a time!

I co-presented with Kristina Rumpff who works at… Read more

1 comments, 2,575 reads

Posted in Mr. Fox SQL on 22 February 2017

SQL Code Guard 2.9 released

Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!

Wait a minute! Almost forgot.
More great news coming soon, stay tuned, subsribe to twitter https://twitter.com/SQLCodeGuard if you don't want miss somthing fun.

Read more

0 comments, 402 reads

Posted in SQL Code Guard on 22 February 2017

What’s a DACPAC and a BACPAC?

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

If you’ve worked with SQL Server development and database projects, you might have heard about DACPACs. However, if you haven’t, this was a concept that didn’t seem… Read more

1 comments, 869 reads

Posted in The Voice of the DBA on 22 February 2017

Automating DBCC PAGE – Part 3 (Is a Clustered Index physically sorted on disk?)

In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by using the DBCC PAGE command and utilizing the “WITH TABLERESULTS” option to be allowed to automate this process for further processing. This post will also do this, but in… Read more

1 comments, 332 reads

Posted in A Discussion of SQL Server-Related Topics on 22 February 2017

Reminder – SQL Saturday Chicago Precon

I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic and I are holding precons the Friday before the event. The SQL Saturday in Chicago this year has hit peak capacity two months before the event. However, if you enroll… Read more

0 comments, 271 reads

Posted in Technobabble by Klee from @kleegeek on 22 February 2017

What’s in my backup file?

Restoring a backup file is pretty easy right?

RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';

Ok, but what if more than one database backup is stored in that single backup file? Didn’t know you could do that?
Yep. You can.

BACKUP DATABASE [Test] TO DISK = 'C:\backups\backup.bak';
BACKUP DATABASE [AdventureWorks2014]…

Read more

0 comments, 717 reads

Posted in SQLStudies on 22 February 2017

SSMS Presenter Mode

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not recommended for production use. There are many enhancements which you can read here: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms-release-candidate but there is one feature I … Continue reading

Read more

1 comments, 442 reads

Posted in All About SQL on 22 February 2017

Remotely Administering the Docker Engine on Windows Server 2016

Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell window when working with Docker on servers. Nothing wrong with this, if you want to know how to do that you can follow my instructions here.

However what if… Read more

4 comments, 553 reads

Posted in The DBA Who Came In From The Cold on 22 February 2017

Read Statistics Histogram using DMV

DMV: sys.dm_db_stats_histogram (object_id, stats_id) 

For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics. It displays current query optimization statistics for a table or indexed view. It was always a painful task, if you wanted to capture output of the DBCC SHOW_STATISTICS for… Read more

4 comments, 298 reads

Posted in SQL Geek on 22 February 2017

We Hired!

The response to our most recent job position was incredible, and I’d like to thank all of the folks who responded and submitted their CVs to us for consideration. In the end, we had one open position, and we selected the most qualified candidate for the position.

I’d like to… Read more

0 comments, 331 reads

Posted in Technobabble by Klee from @kleegeek on 21 February 2017

Newer posts

Older posts