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

Archives: October 2017

Data Visualization Panel at PASS Summit

Next week is PASS Summit 2017, and I’m excited to be a part of it. One of the sessions in which I’m participating is a panel discussion on data visualizationMico Yuk will be our facilitator. I’m in great company as the other panelists are Ginger Grant, Paul… Read more

0 comments, 276 reads

Posted in Data Savvy on 28 October 2017

Exit Codes, systemd and SQL Server on Linux

In this blog post we’re going to cover systemd, process exit codes and highlight how systemd reacts in certain exit conditions from SQL Server on Linux. My friend and SQL Server guru Argenis Fernandez – @dbargenis asked about this behavior on Twitter and I’ve been meaning to write this post,… Read more

2 comments, 625 reads

Posted in Anthony Nocentino's Blog on 28 October 2017

Create a Login in a SQL Server Availability Group

Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where they use the AG databases. An Availability Group consists of (at least) 2 different SQL Servers: Problem In case of a failover, select/insert/update/delete in that database will fail. Explanation A… Read more

0 comments, 31 reads

Posted in SQL Treeo on 28 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, 3,721 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,983 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, 356 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, 204 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


Read more

0 comments, 277 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, 307 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, 284 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,397 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

Read more

0 comments, 442 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, 1,020 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, 232 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,579 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, 1,073 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, 505 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, 276 reads

Posted in The Smiling DBA on 25 October 2017

Newer posts

Older posts