Little info about Resouce DB (SQL Server 2008-2005)
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005)...
Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)
’ll focus on the issues that you need to follow to make sure that you have done everything that you could do to optimize the data access codes you have written or you are going to write in future. The Database Administrators (DBA) also has great roles to play in optimizing and tuning the database performance. But, optimization scopes that fall into a DBA’s area are out of scope for these articles.
Holiday Coverage
It seems that IT people often get stuck working on the holidays, whether being on-call or even dealing with maintenance. We need to remember to rotate that coverage fairly since all of us deserve a break. Steve Jones also reminds you to negotiate compensation.
Resolving User Security Identifier (SID) Discrepancy in Read-Only Databases
Many experienced DBAs understand the issues with matching up users and logins in a restored database. But what do you do when the database is read only? New author Tychang Chen brings us a technique that can help.
Service Pack 4
This week Steve Jones asks if Service Pack 4 for SQL Server 2005 is coming out and makes an argument why it should.
Auditing in SQL Server 2008
Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
TSQL Challenge 20 - finding repeating digits on Fibonacci sequence numbers
Can you generate repeating digits in a Fibonacci series?
Importing SharePoint ULS and IIS Logs into SQL
Importing data into SQL Server is one of the strengths of the platform. However it can require a bit of work for a DBA to make this an automated process. New author David Jansen brings us a technique for importing Sharepoint and IIS logs into SQL Server for later analysis.
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers