SQL Server 2008 introduces " Policy Based Management " (PBM) as a way to better manage your servers. This was a feature that I really thought had, and still has a lot of potential for making the life of a DBA easier. The tagline for PBM is "manage...
2009-03-27
2,334 reads
Operations Manager has stacks of reports to help you monitor your applications' uptime, but reporting can be difficult until you understand all the different options, parameters, and the structure of the Operations Manager health model. Firstly, you need a clear idea about the way that your organization defines 'uptime', and only then you can start your reports. Thomas LaRock explains...
2009-03-27
1,755 reads
A follow-up on Adam Aspin's series about SSRS styles. I have emailed Adam the article because he suggested it would be good to have one here after his works get published.
2009-03-26
7,495 reads
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
2009-03-26
4,688 reads
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2009-03-26
259 reads
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2009-03-26
814 reads
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2009-03-26
304 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to unlock it in a way that works for me. I mentioned it during my series on networking and since I've evolved a strategy that I think is interesting...
2009-03-26
2,334 reads
Using VB Script allows one to script out all the Sql Server objects in independent file.
2009-03-25
10,033 reads
Gail Shaw, the fabled 'gilamonster', earned her MVP and the gratitude of a host of SQL Server professionals seeking technical help with her expert forum posts on SQLServerCentral. She brings great enthusiasm to everything she does, and has a huge influence on the communities she joins.
2009-03-25
2,216 reads
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
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...
Comments posted to this topic are about the item 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