Introduction To Pearl Knowledge Solutions, Inc
Introduction To Pearl Knowledge Solutions, Inc., an ISV and MSP of Remote Database Administration services.....How we're helping small-midsized companies.
Pearl Knowledge...
2009-08-07
819 reads
Blog Posts
PASS News to Be Aware Of
2009 PASS Summit Trip Contest:
If you want an opportunity to win an all expenses paid trip to the PASS Summit,...
2009-08-07
805 reads
Presenting “Understanding Execution Plans”
The PASS Application Development SIG is hosting a web cast next week on Tuesday where I’ll be presenting Understanding Execution...
2009-08-07
820 reads
Tales, Travels and Travails of the NYC DBA....
So, finally, I got my SQLServerCentral.com Blog, that Mr. Jones was kind enough to set up. Many thanks SJ!
My very...
2009-08-07
535 reads
Use SQL Compare by Red Gate to Find a Missing Index
A couple of weeks ago one of our developers sent me an email saying, “I have a query that returns...
2009-08-07
4,362 reads
User Group Presentation: Essential Database Management - Top Ten Recommendations
In the August 13th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG), Paul Randal and his wife...
2009-08-07
328 reads
Book Review: Magnificent Desolation
Magnificent Desolation by Buzz Aldrin ($18 @Amazon) is his second autobiography (haven’t read the first one Return To Earth). I...
2009-08-06
350 reads
Scripting in SSIS
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
2009-08-06
2,235 reads
The effects UNION in a SQL query
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT...
2009-08-06
593 reads
August 2009 Baton Rouge SQL Server User Group – Near Real-time Data Warehousing 1.0
Fresh off of my presentation of the SQL Profiler at SQL Saturday #17 in Baton Rouge this past Saturday, I...
2009-08-05
412 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