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

Archives: October 2017

Line-Continuation in T-SQL

Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e. lines separated by hitting Enter / Return). This is accomplished by ending a line with a particular character that indicates that the line is not ending. For operating system… Read more

1 comments, 2,278 reads

Posted in SQL Quantum Leap on 27 October 2017

Check out my Tips for Friday Blog Series

In case you missed, I started a new blog series several weeks ago called 5 Tips for Friday on SQL Server Best Practices. Every Friday I post a set of 5 best practices on a particular topic. The topic changes from week-to-week. This week’s topic is database configurations: 5 Tips…

Read more

Drop That Schema

An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change. When this need arises, it can turn into a bit of a problem. That is of course if we are… Read more

0 comments, 1,732 reads

Posted in SQL RNNR on 27 October 2017

Cumulative Update #1 for SQL Server 2017 RTM


The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.

Read more

0 comments, 164 reads

Posted in Ganapathi's MSSQLLover on 27 October 2017

Friday Reading 2017-10-27

Morning all! PASS Summit is coming next week but unfortunately I can’t make it this year. I hope everyone who is going has a blast, learns some cool stuff, and meets great people.

Instead I’ll be presenting at the Southampton SQL User Group next Wednesday. Looking forward to this as… Read more

0 comments, 148 reads

Posted in The DBA Who Came In From The Cold on 27 October 2017

SQL Azure Databases - Active Secondary - Failover Groups - Part 4

150th Blog Post . So, the post involves video demo :)

Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few limitations like

* No transparent failover capabilities like Always on Listener

* No availability groups and group failover possible

So,…

Read more

0 comments, 165 reads

Posted in SQL and SQL Only on 27 October 2017

Seattle SQL Pro Workshop 2017 Schedule

Seattle SQL Pro Workshop 2017

You may be aware of an event that some friends and I are putting together during the week of PASS Summit 2017. I have created an Eventbrite page with all the gory details here.

With everybody being in a mad scramble to get things… Read more

0 comments, 244 reads

Posted in SQL RNNR on 26 October 2017

Pass Summit 2017

It’s about that time of year again when there is a buzz in Seattle in regards to PASS Summit. Many data professionals will be heading out to one of the biggest SQL related events of the year. There is excitement for many along with a sense of being overwhelmed for… Read more

1 comments, 162 reads

Posted in The SQL Professor on 26 October 2017

SQL Server Phantom Reads

With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have been inserted after a read operation and becomes visible in a follow-up read operation within the same transaction.

I will show you what this looks like with an example. Please… Read more

1 comments, 1,213 reads

Posted in All About SQL on 26 October 2017

SQL Server – Concat_WS function in SQL Server 2017

Hello friends, Please find the link for my new article at below url – https://social.technet.microsoft.com/wiki/contents/articles/44327.sql-server-concat-ws-function-in-sql-server-2017.aspx    Regards Kapil Advertisements Tagged: concat_ws, Sql Server, SQL Server 2017, Sql Server Developement

Read more

0 comments, 272 reads

Posted in Kapil Blogs on 26 October 2017

Necessity is the Mother of Automation

If you have worked with me or are a frequent reader of my blogs or a frequent attendee of my presentations, you know I hate doing things manually. Over my career, I have found that one of the biggest enemies of automation is being able to get someone else to…

Read more

Repair a Windows Server 2016 installation

This is more for my benefit in the future, but hopefully it can help someone else too. We recently had problems with a development server not installing Windows Updates. The fix was to repair the installation using the Deployment Image Servicing and Management (DISM) tool. All commands should be run… Read more

0 comments, 203 reads

Posted in Born SQL with Randolph West on 25 October 2017

PASS Summit and Redgate Software

Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is because Redgate always does so much fun stuff at Summit. I’m presenting sessions, Steve Jones and our latest (and probably greatest) new team member, Kathi Kellenberger are also presenting sessions.… Read more

2 comments, 169 reads

Posted in The Scary DBA on 25 October 2017

Synchronous VS Asynchronous Statistics Updates

One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously. It’s a simple change that can have a big impact when implemented in highly transactional OLTP environments. Notice I said OLTP not OLAP, since data in… Read more

5 comments, 1,386 reads

Posted in SQLEspresso on 25 October 2017

Basic FORMATting– #SQLNewBlogger

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

I saw the addition of FORMAT() to the T-SQL language, but didn’t play with it much. Recently it appeared in some code, and decided to experiment a bit.… Read more

0 comments, 959 reads

Posted in The Voice of the DBA on 25 October 2017

Schema only backup or schema only DB copy

Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded or re-created. Or maybe you need a copy of the database, but since you don’t need the data, a backup of the 750gb database seems a bit excessive. (I see… Read more

0 comments, 386 reads

Posted in SQLStudies on 25 October 2017

IT Dev Connections 2017

The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers. It was nice to sit with Grant, Andrew, Mindy, Kevin, Tim, Monica, Daniel and Meagan for dinner Monday night.

I attended… Read more

0 comments, 170 reads

Posted in The Smiling DBA on 25 October 2017

Enabling the SQL Server Agent in Linux Containers

At SQL Saturday Holland a few weeks ago I was (surprise, surprise) chatting about containers and mentioned that I hadn’t been able to get the SQL Agent working.

Now, one of the benefits of attending SQL Saturdays is that you get to pick the brains of a lot of very… Read more

0 comments, 1,275 reads

Posted in The DBA Who Came In From The Cold on 25 October 2017

Implementing Temporal Tables Where You Have Existing Data

In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for capturing the change history of data.

One was Change Data Capture which I want into a bit more detail about in Setting up Change Data Capture (CDC)

I also referred… Read more

3 comments, 2,394 reads

Posted in Matthew McGiffen DBA on 24 October 2017

Redgate at Summit 2017

I’ll be heading out to the PASS Summit next week, spending Halloween in a conference center with a lot of other geeks. I know some of you won’t make it, and we’ll miss you, but I understand.

I’m meeting my colleagues from Redgate there, including the new editor of Simple… Read more

1 comments, 992 reads

Posted in The Voice of the DBA on 24 October 2017

Newer posts

Older posts