Move site collections to a new database or || split a content database
Hey Friends,
Sometime we may feel the need to move SharePoint site collection to new content db. Below step can be...
2012-12-11
957 reads
Blog Posts
Optimizing Your BI Semantic Model for Performance and Scale
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented...
2012-12-11
3,011 reads
SQL Live 360 Kicks off Today!
Hello Dear Reader! Today in beautiful Orlando FL at the Loews Royal Pacific Resort the Live 360 Conferencekicks off. Live...
2012-12-11
888 reads
SQL Server 2012 security: Changes for the newest version
Database infrastructure security is extremely crucial for any organization, which is why Microsoft has invested heavily in SQL Server security...
2012-12-11
1,178 reads
SQL Server Disaster Recovery
I was reading a blog post by Steve Jones on Monday and I started to write a comment on his...
2012-12-11
1,094 reads
T-SQL Terminator
You may have noticed in my code examples, I always include a semicolon ";" at the end of my TSQL statements. ...
2012-12-11
1,023 reads
T-SQL Tuesday #37 – A Month of Joins
It’s time once again for T-SQL Tuesday, and this month is hosted by SQLity.net, Sebastian Meine.
If you want to know...
2012-12-11
1,488 reads
TSQL Tuesday #37 – Joins and Implicit Conversions
Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this...
2012-12-11
2,012 reads
T-SQL: CASE Statement
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-11 (first published: 2012-12-03)
5,085 reads
Copying Connection Managers in SSIS
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,551 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers