Quick Tips–Using ii in #SQLPrompt
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-10-21 (first published: 2016-09-27)
1,842 reads
Blog Posts
VMworld Europe 2016 Wrap Up
This past week I had the pleasure of attending our first VMworld Europe conference, held this week at the Fira Gran Via in...
2016-10-21
728 reads
Another way to move SQL DB to Azure
About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...
2016-10-20
472 reads
Control Flow Package Parts in SSIS 2016
Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server...
2016-10-20 (first published: 2016-10-14)
3,560 reads
Creating a Logon Trigger–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-10-20
554 reads
I like you, but I don't like your best practice (power plans)!
I saw this tweet from the always awesome @DBArgenis and @sqldbawithbeard and couldn't help but feel a bead of sweat...
2016-10-20
139 reads
Machine Learning – What is It Good For?
Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...
2016-10-20
425 reads
Making the Most of PASS Summit and Similar Events
Events like the PASS Summit aren’t just about education. They are a chance to meet new people, get some distance from...
2016-10-20
448 reads
PASS Summit 2016: Dinner, Dinner, Game
Part of making a week long trip to a big event like the PASS Summit successful is finding something to...
2016-10-20
438 reads
SQL Saturday Washington DC Preconference Training Session
I am pleased to announce that we are launching our next round of all-day precon training session at the upcoming SQL Saturday in Washington...
2016-10-20
453 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers