Speaking at Knoxville SQL Server User Group
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
990 reads
Blog Posts
SQL Server Error Logs
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about...
2012-01-04
1,080 reads
SQL SERVER REBUILD INDEX
Use the script below to rebuild an index on a table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME REBUILD ;
Check SQL Server...
2012-01-04
1,044 reads
SSIS Community Tasks and Components
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,092 reads
SSIS ETL Frameworks
In my years as a BI Professional I have seen many ETL Frameworks. They range from homegrown internal solution to...
2012-01-04
9,686 reads
Dropping a Database
I came across an issue on a server this morning where a drive had run out of free space. Now given...
2012-01-03
618 reads
Estimated Completion Time for Backups and Restores
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
80,625 reads
SQL SERVER DISABLE INDEX
Use the script below to disable an index on a SQL Server table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME DISABLE;
Executing the...
2012-01-03
1,442 reads
Start 2012 with Your Best of 2011
The first week following on from the Christmas break is a very hectic one for us Data Professionals.
Your customers are...
2012-01-03
623 reads
Windows OS Information from SQL Server
I ran across a thread recently where someone was asking how to get the Windows start time from within SQL...
2012-01-03
1,082 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Wisma Mulia CSTelpon : 0853-73737551
Jl. Gatot Subroto No.42 Suite G02, Kuningan Bar., Kec. Mampang Prpt., Kota Jakarta Selatan,...
BCA KCP Hasanudin CSTelpon : 0853-73737551
Jl. Sultan Hasanuddin Dalam No.43/48, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus...
BCA KCP Tebet CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N &...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers