PowerShell vs GUI Availability Group Rebuild
Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands
Trust
Why does the IT industry seem to act and run so differently than many other industries? Steve Jones takes a stab at explaining this.
Getting Started with the SSAS Tabular Model
SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to provide a rapid and powerful way of providing self-service BI to client applications such as Microsoft Excel and Microsoft Power View. You’ve deployed SSAS in tabular mode, and deployed Adventureworks into it. What next? Rob Sheldon explains all.
SQL Saturday #229 - Dublin
SQL Saturday Dublin is hosting a two-day training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development. The free training event will be Saturday June 22 2013, and three preconference sessions (not free) will take place the 21st.
Custom Sequence Numbering
This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function
Do You Want a Meritocracy at Work?
The best at their crafts are usually the most rewarded in sports, but not necessarily in other fields. This week Steve Jones asks if you would like it to be different?
Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.
SQL Server Integration Services Package Restartability
I've tried using SSIS checkpoints, but have found them to be difficult to configure and, on occasion, unpredictable. Is there a better way to build in restartability in my SSIS packages?
Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container
An SSIS ETL package created with the Import/Export Wizard uses a Data Flow Task to process one data file at a time. If the need arises, however, the Data Flow Task generated by the wizard can be embedded inside a Foreach Loop Container to batch-process a continuous stream of data files.
Moving Data From Excel to SQL Server - 10 Steps to Follow
SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates the advantages of the graphical approach of SSIS. Andy Brown explains.
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
Bank BCA KCP Suari CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah...
BCA KCU GANG TENGAH CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah...
BCA KCP Pandanaran CSTelpon : 0853-73737551
No. 101 A, Jl. Pandanaran, Mugassari, Kec. Semarang Sel., Kota Semarang, Jawa Tengah 50243
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers