Microsoft MVP Grant Fritchey provides an insight into the key findings from the report; what is the biggest challenge facing database professionals this year? How are estates changing? And what technologies are being used across the industry? Read Grant’s blog to find out.
In this tip we look at how to build a hierarchy chart using the SQL Server hierarchyid data type and Excel to format the chart.
In this piece, learn about changes in UK holidays and get a script to calculate them.
Ransomware is becoming a bigger and bigger problem. Steve has some thoughts on how you should think about security in your database environment.
Learn how data protection legislation is changing around the world and the 10 steps database teams can take to ensure compliance and defend against data breaches.
Data sources and datasets are critical components of an SSRS report, but many people new to SSRS struggle to understand them. In this article, Kathi Kellenberger shows you how to create these components and explains when they should be shared vs. embedded.
I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. A familiar tale he tells is about when he wrote the song Yesterday. He woke up with the tune […]
CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.
You’ve decided that you need to offload reports to a different SQL Server, and you’re willing to pay the costs. Here are the most common ways to move the data from production to a reporting server, arranged roughly from easiest-to-implement to hardest.
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...
This is the first in a series of posts about gatekeeping in Information Technology...
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Trying to understand why when I search for numerics in full text, contains does...
MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...
I have a package running in SQL 2016 using Project Deployment. One of the...
Ask SSC