SKUUpgrade =1 in SQL 2005
One of the things on my todo list for this past week was to upgrade a SQL 2005 Standard Instance...
2009-10-13
735 reads
Blog Posts
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-13
3,998 reads
SQLServerCentral Article on Database Space Capacity Planning
I wrote an article for SQLServerCentral entitled "Database Space Capacity Planning" that demonstrates a database and volume (disk) capacity planning solution...
2009-10-13
1,000 reads
Table Variables Are Only in Memory: Fact or Myth
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
671 reads
A Not Quite Average Sunday
Ever had a day when a bunch of small things run together to create a day you wish you had...
2009-10-12
325 reads
Afraid of Presenting? Try Toastmasters
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,328 reads
Carolina Code Camp - The Good and the Bad
This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was...
2009-10-12
929 reads
Congratulations to John Magnabosco
Congratulations to John Magnabosco for being awarded as a Microsoft MVP. I met John last year at the Indy Tech...
2009-10-12
616 reads
Congratulations to John Magnabosco on SQL MVP Status
See his quiet post about it here. This comes right after finishing up his first book titled Protecting SQL Server...
2009-10-12
280 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-12
3,352 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers