SQLSaturday SLC 2010
Well, I have taken another plunge. I finally got around to submitting a session for SQL Saturday Salt Lake City...
2010-09-01
510 reads
Blog Posts
The DBAs Joke of the Day: Which RDBMS Was that You Say?
So someone walks in from another department and asks about hosting some new high volume, huge database that pushes data...
2010-09-01
615 reads
Using WITH NOLOCK
A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK...
2010-09-01
544 reads
A PASSionate Community
Much has voiced about the Professional Association for SQL Server (PASS) Nominating Committee’s decision to not put Steve Jones (blog,...
2010-08-31
1,552 reads
Come and gone
Or “Plan cache monitoring – insert and remove”
Previously I took a look at the CacheHit and CacheMiss events to see how...
2010-08-31
1,814 reads
Determining the no of processor cores in your SQL Server
SELECT cpu_count/hyperthread_ratio AS cores FROM sys.dm_os_sys_info;
2010-08-31
1,673 reads
Does Join Order Matter?
According to Conor Cunningham, it doesn’t.
I have heard that there are issues in the optimizer, and to be sure, there...
2010-08-31
1,829 reads
How to fix Orphaned Users
To view if there are any orphaned users, run this query against the DB;
sp_change_users_login ‘report’
To fix;
sp_change_users_login ‘update_one’, ‘dbUser’, ‘sqlLogin’
2010-08-31
1,888 reads
Interview with SQL Server MVP Glenn Berry
This is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections...
2010-08-31
2,506 reads
Maintenance Plan "No description found" error
for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description...
2010-08-31
2,767 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