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

Latest Blog Posts

Power BI Custom Visuals Class (Module 56 – Rotating Tile)

In this module you will learn how to use the Rotating Tile Custom Visual.  The Rotating Tile gives you the ability to display multiple metrics on a single visual that rotates through each value you wish to display.  This allows you to save valuable space on your reports!

Module 56…

Read more

1 comments, 204 reads

Posted in Devin Knight on 20 June 2017

Database Fundamentals #3: What’s In a Database?

It’s worth noting that a lot of people will never need to create their own database. You may never create your own tables or other data structures either. You may only ever run backups and restores and manipulate the security on the system and let application installs create databases for… Read more

2 comments, 121 reads

Posted in The Scary DBA on 20 June 2017

Statistics and Cardinality Estimation

Cardinality

This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”. In SQL we’re continually dealing with sets so this becomes a very relevant topic, which in our context is just the “number of rows”.

When you have a query… Read more

0 comments, 138 reads

Posted in Matthew McGiffen DBA on 20 June 2017

How the Initial VLF sequence number gets decided of the default transaction log file

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed the undocumented command DBCC LOGINFO, one of the common questions which I got – ‘How the Initial VLF sequence number gets decided of the default transaction log file’?… Read more

0 comments, 133 reads

Posted in SQL Geek on 20 June 2017

DevOps – Downloading a File from the Internet with PoSh

One of the things we need to do as data professionals is move data files around. Often we’ll get a local path, but in looking for public data sets, I wanted to get a file from the Internet. In this case, a rather large file.

I could have put the… Read more

2 comments, 181 reads

Posted in The Voice of the DBA on 19 June 2017

PASS Security VC Presentation – The Dirty Business of Auditing

On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.

Registration Link

Here’s what I’ll be speaking on:

The Dirty Business of Auditing

Auditing is often a dirty word among DBAs because it equates to more work with… Read more

0 comments, 99 reads

Posted in Databases – Infrastructure – Security on 19 June 2017

dbfs – command line access to SQL Server DMVs

With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools. In the Linux world we have a set of tools that work with our system performance data and present that to… Read more

0 comments, 212 reads

Posted in Anthony Nocentino's Blog on 19 June 2017

The Three T’s of Backups

I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume, extreme volume), and evidently I have to say it again. Simply creating a backup file is not enough to ensure the protection of your information. In… Read more

5 comments, 1,308 reads

Posted in The Scary DBA on 19 June 2017

Webinar with Rubrik: Simplifying SQL Server Data Protection – Near Zero RTO

I am very proud to contribute to a new webinar with Rubrik on Thursday, June 22 at 8AM PT / 11AM ET where we talk about the trials and tribulations of living as a Database Administrator and the challenges when handling SQL Server backups with the same tools as a… Read more

0 comments, 89 reads

Posted in Technobabble by Klee from @kleegeek on 19 June 2017

SQL Server TDE – Is TempDB Encrypted?

A really quick one today, something that made me think for a minute and I thought it might make others think too. So you have enabled TDE  – Transparent Data Encryption (you can see these previous posts here: https://blobeater.blog/?s=tde&submit=Search) on your SQL … Continue reading

Read more

1 comments, 123 reads

Posted in All About SQL on 19 June 2017

Adding Identity to an existing column

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He then ran into an issue where he had to have one. The easiest thing is to create a new int column with an identity column right? Unfortunately in this case… Read more

1 comments, 140 reads

Posted in SQLStudies on 19 June 2017

Microsoft Professional Program in Data Science – Continued

A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve now finished the remainder of the courses. Now I only need to finish the capstone project. This project only occurs at the start of each quarter and runs for a… Read more

0 comments, 1,376 reads

Posted in Koen Verbeeck on 19 June 2017

Understanding Relative Risk – with T-SQL

In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a term that is important to understand when you are doing comparative studies of two groups that are different in some specific way. The most common usage of this is… Read more

0 comments, 1,251 reads

Posted in Mala's Data Blog on 19 June 2017

Monday Coffee – SQL Saturday Dublin

Last weekend was SQL Saturday Dublin, and it was a good one.

My session on An introduction to SQL Server & Containers was the first one of the day, scheduled for 8am; now for me that’s great as I tend to get a bit nervous beforehand so having the… Read more

0 comments, 101 reads

Posted in The DBA Who Came In From The Cold on 19 June 2017

PASS Board Elections

Well, it is almost that time of the year again. Elections for the PASS Board.

This is a great way to show your passion for this wonderful community of SQL Server or now, Microsoft Data Professionals. It looks like it is getting harder and harder for someone to come up… Read more

0 comments, 112 reads

Posted in The Smiling DBA on 19 June 2017

Great to see you at SQLSaturday Houston 2017

Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers. I presented in the first timeslot of a stacked schedule, and met and made a lot of friends.

My talk on SQL Server Permissions and Security Principals had a…

Read more

0 comments, 96 reads

Posted in SQL Tact on 17 June 2017

Friday Reading 2017-06-16

Been looking forward to this weekend for a while now as it’s SQLSaturday Dublin tomorrow. I did a lightening talk at SQLSat Dublin 2016 and am really chuffed to have a full session this year. There’s a whole bunch of great sessions, Bob and the team always put on a… Read more

0 comments, 134 reads

Posted in The DBA Who Came In From The Cold on 16 June 2017

Install SQL Server Agent on Ubuntu (Linux)

With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to schedule any task using a SQL Server Agent Job on Linux machine. In this post, I will explain how to install the SQL Server Agent package on the Ubuntu system. Read more

0 comments, 227 reads

Posted in SQL Geek on 16 June 2017

Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of different sessions for attendees and for us to watch! In total, there are 75 different videos between the keynotes and the individual sessions posted on the Microsoft Power BI YouTube… Read more

5 comments, 950 reads

Posted in SQL with Dustin Ryan on 15 June 2017

Renaming MDF/LDF Files–SQLNewBlogger

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

I would guess many people would run into this situation at some point. A developer or DBA creates a database, then decides to rename it, but the… Read more

0 comments, 279 reads

Posted in The Voice of the DBA on 15 June 2017

Newer posts

Older posts