SQL Saturday is a full-day technical conference and training event with international speakers. With over 20 sessions on SQL Server and a separate pre-con, the event is aimed at all those interested in SQL Server - from pros to beginners. This event will be on February 28, 2015, so register while space is available.
This article is about how a view works when it is created on a table with clustered columnstore index on it.
Today we have a guest editorial from Andy Warren with a few hints on how you can continue to be proactive as a DBA.
After discussion the main concepts and basic API calls for Azure Storage Queues in parts 1 and 2 of this series, Roman Schacherl turns his focus to two topics that no one likes to implement but everybody needs: security and performance.
A fundamental way that SQL Server determines whether a principal has the permissions necessary to execute code is with its execution context rules. It’s all complicated by the possibility that a principal has permission to execute code but doesn’t have permission on the underlying objects accessed by the code, such as the data in a table. This stairway level will explore SQL Server’s execution context, ownership chains, and impersonation, as well as show you how you can control access to data via T-SQL code.
SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keeping an eye out for problems. It comes into its own when you have figured out how to configure it to run on maybe hundreds of instances using Central Management Server. Dennes describes how to tame the system so that it scales.
This metric can help if you want to monitor the number of indexes per database that haven't been used for the last month. Indexes that aren't in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space.
As data professional I have played with Analytics and found I'm better suited to development and administration, and that's ok.
Big data is everywhere, and most large IT enterprises have installed one or more big data applications. These applications provide fast access to large stores of data, usually customer or sales data. Your technical staff that supports these applications and the systems that analyze and consume the data didn't exist ten years ago. Who are these new IT professionals, and how should you manage them?
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers