How do I move a SQL login from one server to another without the password?
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...
2013-04-03 (first published: 2013-03-25)
9,549 reads
Blog Posts
Pragmatic Works' Master SSIS Workshop coming to NYC
Pragmatically
speaking, there’s no way you can learn all there is to know about Microsoft’s
native ETL tool, SQL Server Integration Services...
2013-04-03
2,109 reads
Tomorrow: NYC Metro SQL Server User Group Presents Paul Randal and Kimberly Trip
Well, they're baack in the City!Coming this Thursday April 4, 2013 to the Big Apple, hosted by the NYC
Metro SQL...
2013-04-03
940 reads
Total Number Of Records In each Table
Quite often in our day today activity we need to check the count of records in each table of the...
2013-04-03
711 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known...
2013-04-02 (first published: 2013-03-25)
3,970 reads
Madison SQL Saturday (#SQLSat206) Is This Weekend
Crack a beer and melt the cheese, the Madison SQL Saturday is this weekend. Don’t wait any longer because you...
2013-04-02
492 reads
Merging SQL Server and Softball Just for Fun
With opening day of Major League Baseball season finally here, I thought I’d take the time to cover two of...
2013-04-02
1,283 reads
Microsoft BI tools: How they use data sources
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,266 reads
Reminders and Rehearsal
I’ve spoken at quite a few SQL Saturday events. I won’t hit 50 this year, like Kevin Boles, but by...
2013-04-02
791 reads
The New MidnightDBA.com is live!
GUYS! GUYS! GUYS!!! We’ve finally completed the MidnightDBA.com facelift that many of you have been begging (nagging, pining, etc.) for,...
2013-04-02
628 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