2011-03-16
1,665 reads
Articles
Change Server Collation in SQL Server 2008
How can I change the collation of SQL Server 2008? Learn how in this short tutorial.
2011-03-15
6,968 reads
Spring SQL Connections 2011 and SQLServerCentral.
Once again SQLServerCentral is sponsoring a track at SQL Connections in Orlando this March. Read about the event and our speakers and join us for SQL Server training in Florida.
2011-03-15 (first published: 2011-01-19)
1,699 reads
A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-15
1,831 reads
How to Identify CPU Bottlenecks in SQL Server
We experience regular slowdowns on our MS SQL database. After analyzing the memory usage we would like to continue the root cause investigation by examining CPU bottlenecks. What is your recommendation to recognize CPU related bottlenecks in SQL Server?
2011-03-15
6,215 reads
Changing the default port numbers when configuring database mirroring
There are times when you need to use different network ports to communicate between two servers running database mirroring. Learn how to change the default ports.
2011-03-14
10,664 reads
SQL Server CASE Law
SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.
2011-03-14
6,011 reads
Common SQL Server Mistakes
A presentation by Steve Jones that looks at a number of common mistakes that people make with SQL Server on a regular basis.
2011-03-11
498 reads
How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
2011-03-11 (first published: 2009-11-03)
30,509 reads
The Modern Resume - Building Your Brand Online
A presentation by Steve Jones that gives practical tips for enhancing your online brand and making yourself stand out in the modern world.
2011-03-11
342 reads
Blogs
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...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
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