Identity Column Increment Value (EVEN/ODD)
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-24 (first published: 2015-11-18)
4,528 reads
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-24 (first published: 2015-11-18)
4,528 reads
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-17
129 reads
What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...
2015-10-27 (first published: 2015-10-20)
4,558 reads
What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....
2015-10-20
122 reads
For many years I didn’t really think about the implications of how I was retrieving data from my SQL Servers...
2015-10-13
13,483 reads
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,353 reads
I was doing a database code deployment the other night and the first step in the release plan was “Take...
2015-09-29 (first published: 2015-09-23)
7,022 reads
Thanks to MidnightDBA (b/t) for hosting this month’s #tsql2sday.
Strategies for managing an enterprise.
What do you think of when you...
2015-09-17 (first published: 2015-09-08)
1,053 reads
During my presentation at SQL Saturday Albany I was asked a question about the error buffer that I didn’t know...
2015-08-04
1,154 reads
SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session
So that picture to the right is me out front of...
2015-07-28
702 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
In today's fast-paced world of digital marketing, businesses need to choose the right agency...
Comments posted to this topic are about the item The Journey to Change
Comments posted to this topic are about the item Check Azure SQL DB Space...
I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:I now run this command:
DBCC CLONEDATABASE(sandbox, sandbox_clone); GOWhen I examine the database file properties, what do they show? See possible answers