Win a SQLBits Pass
You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...
2016-04-08
564 reads
You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...
2016-04-08
564 reads
2016-04-08
1,186 reads
I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post...
2016-04-07
607 reads
Naming objects and variables in software can create contention in a team. While there are good conventions and standards, ultimately a team just needs to agree on something.
2016-04-07
139 reads
What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted?...
2016-04-06
830 reads
2016-04-06
1,776 reads
2016-04-05 (first published: 2011-12-05)
466 reads
2016-04-05
1,364 reads
What do you do if you need a process running under Local Service to connect to your SQL Server? Most...
2016-04-04
647 reads
When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the...
2016-04-04
1,038 reads
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
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