Grant EXEC on all Stored Procedures to a Role
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
24,291 reads
Articles
The PoSh DBA – Specifying and Gathering Performance Counters
If you need to keep tabs on a number of servers and applications in a Windows domain then performance counters provide the bedrock of information. It is important to identify the counters you need and gather baseline data to allow you to create alerts when abnormal conditions occur.
2014-03-20
3,753 reads
Microsoft SQL Server 2014 released to manufacturing
, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on April 1.
2014-03-19
8,254 reads
Review Your BUCKET_COUNT Statistics with DMV
Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.
2014-03-19
2,032 reads
Creating a Date Range from Multiple Rows Based on a Single Date
When you've got only a single effective date on a record and you need to artificially create the effective end date based on a following row in T-SQL, the techniques discussed in this article will help you decide what is best.
2014-03-18
33,595 reads
SQL Server Luxembourg: Natural Born Killers
The SQL Server Luxembourg user group will be meeting on March 26. This is a free event for all registered attendees, and will feature Richard Douglas and Tom Van Zele as speakers.
2014-03-18
512 reads
Paul Randal: Geek of the Week
Paul Randal and Kimberly Tripp, together with their small team of experts at SQLSkills.com, dominate the high-end training and consultancy for SQL Server. We sent Richard Morris to find out a bit more about Paul, his views about SQL Server, his lifestyle, ambitions and plans.
2014-03-18
2,910 reads
Windows Azure SQL Database - Uploading Data by Using the bcp Utility
Instead of using a custom SSIS-based project to upload content from an on-premise SQL Server database to Azure PaaS-based SQL Database, Marcin Policht presents an alternative approach. Using the bcp utility not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.
2014-03-17
3,582 reads
Automate Sliding Window Partition Maintenance: Part II
Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.
2014-03-14 (first published: 2010-12-21)
10,024 reads
Big Data Basics - Introduction to HDFS
One of the core components of the Hadoop framework and responsible for the storage aspect is HDFS. Unlike the usual storage available on our computers, HDFS is a Distributed File System and parts of a single large file can be stored on different nodes across the cluster. Here are some of the key concepts related to HDFS.
2014-03-14
4,123 reads
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Adding and Dropping Columns I
Comments posted to this topic are about the item Adding and Dropping Columns I
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers