Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

SQL Server Indexing Book Giveaway – Week 6 (Index Myths)

And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway.  So far, I’ve sent out five copies of the book based on comments from these (1, 2, 3, 4, and 5) posts.

Expert Performance… Read more

5 comments, 180 reads

Posted in StrateSQL on 14 July 2016

Getting Table Change Scripts–#SQLNewBlogger

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

One of the really basic things I think everyone should understand is how to get scripts from Management Studio (SSMS) and saving them. In fact, I’ve written… Read more

0 comments, 254 reads

Posted in The Voice of the DBA on 14 July 2016

Altering a column in a large table: A case study

Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to share each of them and the results of those I tried. I will not be giving any specific examples or code. Feel free to give me your opinion in the… Read more

6 comments, 418 reads

Posted in SQLStudies on 14 July 2016

Get Your Email Out of my ETL

Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My response: “I don’t.” The tl;dr version of this post is I let my extract-transform-load processes do just ETL, and leave notifications to the scheduling system where they belong. Get Your… Read more

0 comments, 315 reads

Posted in Tim Mitchell on 14 July 2016

Live From @LearningTree London Backup and Restore - Day 3

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks success live blogging from the back of the room whilst producing the 294 influence skills course, this week I’m in the process of trying this from the front…

Read more

0 comments, 168 reads

Posted in The SQL DBA in the UK on 14 July 2016

SQL Server Desired Enhancements

Happy Belated Birthday

The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month – or at least is supposed to happen on that day. This month, the formidable Chris Yates (blog | twitter) has invited everybody to a birthday party Read more

4 comments, 168 reads

Posted in SQL RNNR on 13 July 2016

Source Control for the Reluctant DBA

This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I encountered at work and how they provided the inspiration for using source control in my SQL Server projects. This post will focus on using the version control system… Read more

1 comments, 305 reads

Posted in The Database Avenger on 13 July 2016

Getting Started with Database DevOps, DLM, and New Tools

Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh showing off Git, Team City, and Octopus Deploy as the main tools. Register today and see how you can get started.

We’ve been running this series for a year, with… Read more

0 comments, 219 reads

Posted in The Voice of the DBA on 13 July 2016

Azure SQL Data Warehouse is now GA

The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available.  Here is the official announcement.

In brief, SQL DW is a fully managed data-warehouse-as-a-service that you can provision in minutes and scale up in seconds.  With SQL DW, storage and compute scale… Read more

2 comments, 183 reads

Posted in James Serra's Blog on 13 July 2016

Thanks, Karla

I heard the news this week, and I’m still sad. Karla Landrum is leaving PASS after five years of acting as the Community Evangelist.

Thank you, Karla, for all you’ve done.

In the last five years, we’ve seen tremendous growth in the SQL Saturday franchise, as well as other chapters.… Read more

1 comments, 173 reads

Posted in The Voice of the DBA on 13 July 2016

Live from @LearningTree London - Security Day - Day 2

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks success live blogging from the back of the room whilst producing the 294 influence skills course, this week I’m in the process of trying this from the front…

Read more

0 comments, 110 reads

Posted in The SQL DBA in the UK on 13 July 2016

SQL Server – How to retrieve SQL plans from Cache

Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache. In SQL Server there are multiple DMV (Dynamic Management Views) and DMO (Dynamic Management Objects) which can be used to retrieve the information about execution plan. Sys.dm_exec_query_plan is most commonly…

Read more

1 comments, 302 reads

Posted in Kapil Blogs on 13 July 2016

T-SQL Tuesday #80 – SQL Birthday Present

It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and happens to fall on the hosts birthday. First order of business is to wish our host, Chris Yates (blog|@YatesSQL), a very happy birthday! The next order of business is to…

Read more

Power BI Custom Visuals Class (Module 07 – Enhanced Scatter)

In this module you will learn how to use the Enhanced Scatter Power BI Custom Visual.  This new-and-improved scatter chart allows for more customization and better data representation over the standard scatter chart that is provided to you by default with Power BI.

Module 07 – Enhanced Scatter

Downloads

  • Power…

Read more

2 comments, 155 reads

Posted in Devin Knight on 12 July 2016

T-SQL Tuesday #080 – The Gift of the Basics - Syndication – WaterOx Consulting

This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s theme was to be a gift to the community of something you had to offer that someone else may find as a gift. Or maybe it isn’t. That’s my interpretation.…

Read more

0 comments, 197 reads

Posted in WaterOx SQL on 12 July 2016

Default database file sizes

It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing blog posts! Well, technically it’s T-SQL Tuesday again, but we can pretend we are writing for Chris’ birthday. In fact that’s the subject he’s selected. “Give… Read more

5 comments, 269 reads

Posted in SQLStudies on 12 July 2016

T-SQL Tuesday #80–Chris Yates’ Birthday

It’s the 80th version of T-SQL Tuesday. You can see all the parties from the past on my page, but feel free to jump in here or elsewhere. This is a monthly event, where anyone can write on a topic.

This month’s invitation is from Chris Yates, with today being… Read more

0 comments, 171 reads

Posted in The Voice of the DBA on 12 July 2016

Are you a new SQL Server DBA? Live Blog @LearningTree

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration course in LEC in London. Following on from last weeks success live blogging from the back of the room producing the 294 influence skills course, this week I’m going to try it from the front of the class.

Read more

0 comments, 179 reads

Posted in The SQL DBA in the UK on 12 July 2016

Training To-Do List for New DBA

Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the bottom of a very tall ladder? Don't have much of a budget for training?

Here's a list of resources I'd recommend, in no particular order.

EDIT: I presented this content,…

Read more

5 comments, 2,804 reads

Posted in SQL Tact on 12 July 2016

Improvements with SSMS 2016

The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However, it's also been behind the development cycle of visual studio, and didn't have continual updates. That changed recently, as I've previously posted on. SSMS (Sql Server Management Studio) now being… Read more

0 comments, 2,178 reads

Posted in SQL Barbarian on 11 July 2016

Newer posts

Older posts