SQL Server Security Best Practices
Learn how to secure your data by implementing SQL Server security best practices.
2001-09-20
3,675 reads
Additional Articles
DBCC SQLPERF (Logspace) Reporting Internals
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
2001-09-17
1,927 reads
Support for Network Database Files
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
2001-09-14
1,145 reads
Microsoft SQL Server OLAP Services Cell-Level Security
This article describes how SQL Server 7.0 (Service Pack 1) OLAP Services takes advantage of the user and group structure in Microsoft Windows NT to offer cell-level security, and describes several ways to tailor permissions to data across the enterprise.
2001-09-13
1,358 reads
Connection Pooling with Microsoft SQL Server 2000 Analysis Services
This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)
2001-09-11
1,661 reads
SQL Server Database Coding Conventions and Best Practices
Learn the key basics of writing quality Transact-SQL code.
2001-09-07
6,666 reads
Measure for Measure
Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.
2001-09-06
1,614 reads
What is OLAP?
An interesting question and one that The OLAP Report attempts to answer. This article is an analysis of what the increasingly misused OLAP term is supposed to mean.
2001-09-05
1,422 reads
SQL Server 2000 User-Defined Functions White Paper
The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.
2001-08-31
2,233 reads
OLAP Services: Managing Slowly Changing Dimensions
Amir Netz is one of the true OLAP and SQL Server gurus at Microsoft. If you ever get the chance to see him speak, go. This is one of his articles examining OLAP services.
2001-08-30
2,324 reads
Blogs
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Forums
Case statement with time
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
what are the best books to become a DBA SQL?
Ask SSC