Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
Operating system Error 112
The error message pops up when you try to restore the database to a different server or to a desktop or to a FAT32 file system. Learn a couple of ways for dealing with this error.
Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO
This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.
How To Read A PayPal Notification Email
Learn how to read information from a PayPal Notification email by using Microsoft Access, Outlook and VBA.
Networking = Business Cards
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a few hits for opening up my Linked In network to include those of you who read my blog regularly and want to connect. The essence ...
Dreaming of Clouds
Day four of a "Week in the Clouds" has Steve Jones dreaming of some exciting possibilities for SQL Server and cloud computing.
Introduction to Profiler
This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.
Setting Up a Publisher - SQL School Video
Replication can be a complicated undertaking for many people. Learn how to get started by creating a publisher in this SQL School video from MVP Andy Warren.
Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
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