SQL Server Security Best Practices
Learn how to secure your data by implementing SQL Server security best practices.
Learn how to secure your data by implementing SQL Server security best practices.
Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.
This is the funniest error message Brian Knight has ever seen in SQL Server.
Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
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.
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
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)
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
I have a numeric column called "Value" in a flat file, which contains both...
I have a numeric column called "Value" in a flat file, which contains both...
Comments posted to this topic are about the item Are We Dinosaurs?
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers