SQL Server 2012 Licensing VMs without SA
I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and...
2012-01-06
2,009 reads
31 Days of SSIS in a PDF
At some point last year after finishing the 31 Days of SSIS, I decided to bundle up all of the posts...
2012-01-09 (first published: 2012-01-05)
7,136 reads
PASS Summit Eval – Extended Events
As I mentioned in yesterday’s post, I had two sessions at the PASS Summit this past year in which I...
2012-01-05
751 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,252 reads
Msg 7395: Unable to start a nested transaction
Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...
2012-01-05
3,383 reads
LOOP, HASH and MERGE Join Types
Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences,...
2012-01-05
5,887 reads
SQL Server – Identifying default data directory for multiple instances through registry
This is a follow up post from a comment on my blog.
Earlier I posted about using xp_instance_regread to get default...
2012-01-10 (first published: 2012-01-05)
2,868 reads
Safely Restart SQL Agent with Powershell
I recently had to enable tokens in SQL Agent across about 50 instances. Unfortunately, enabling tokens requires a SQL Agent...
2012-01-05
1,776 reads
SSRS - Embedded Custom Code
When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting...
2012-01-12 (first published: 2012-01-05)
4,728 reads
SQL Server Disable Indexes and Rebuild Indexes dynamically
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the...
2012-01-05
1,182 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat Telp BCA KCP Bona Indah +62 838-4945-0961
Wa:083849450961 Plaza Bona Indah Jl. Karang Tengah Raya Blk B/12, RT.1/RW.6, Lb. Bulus, Kec....
Alamat Telp BCA KCP Cirendeu +62 838-4945-0961
Wa:083849450961 Jl. Raya Cirendeu No.14, Cireundeu, Kec. Ciputat Tim., Kota Tangerang Selatan, DKI Jakarta...
Alamat BCA KCP Altira Sunter Telp 0821 6277 387
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, RT.9/RW.11, Sunter Jaya,...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers