The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.
2016-11-28 (first published: 2016-11-23)
3,352 reads
Ahmad Yaseen explains how you can control the number of processors assigned to the SQL Server DBCC CHECKDB command in order to free-up the server's resources.
2016-10-28
3,392 reads
One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.
2017-09-04 (first published: 2016-10-18)
7,583 reads
SQL Server 2016 introduced three new objects to deal with the greater demand of data; John Miner takes a look at this new functionality.
2016-10-13
4,605 reads
2016-10-07
1,032 reads
There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define these different kinds of masking rules - Greg Larson explains.
2016-09-29
5,212 reads
Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.
2016-09-22
4,108 reads
Arshad Ali takes a look at traditional analytics architecture, the challenges it faces, and how the newly introduced Real-time Operational Analytics feature overcomes those challenges.
2016-09-12
3,683 reads
When writing T-SQL code, we often write code to check if the database object exists first and then take some action. In this tip John Miner covers the new and easier way to do this in SQL Server 2016.
2016-09-01
7,255 reads
2016-08-09
1,011 reads
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Now that your CFS has been setup it’s time to get the word out...
So I have inherited an older SQL 2014 Server and have been working on...
Hi, I need to update my sql script and remove the UNION but get...
Looking for a HA solution for SQL server for our branch offices. Current setup...
Ask SSC