File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing...
2016-04-11 (first published: 2016-03-29)
1,934 reads
SQL Server Failover Cluster Configuration & its Hardware Compatibility
Introduction
Failover cluster in SQL Server is a type of cluster in which two or more independent servers are interconnected with...
2016-03-29
882 reads
2016-03-29
495 reads
Notes from the March 2016 oPASS Meeting
Quick notes:
Chinese food instead of pizza (thanks Shawn!)The wine bar is doing some remodeling to make better use of the...
2016-03-28
597 reads
Why I Love #SQLSaturday
PASS SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of...
2016-03-28
477 reads
Query Store and Optimize For Ad Hoc
I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...
2016-04-11 (first published: 2016-03-28)
1,944 reads
Utility function: dbo.JobName(@job_id)
As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...
2016-04-08 (first published: 2016-03-28)
1,489 reads
SQL Nexus in Copenhagen
The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the...
2016-03-28
596 reads
Why you shouldn’t use SELECT *
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
507 reads
Using PowerShell to set Extended Events Sessions to AutoStart
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,697 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Alamat BCA KCP Pasar Minggu Center Tlp:08218200203
Telp/WA 62 8218200203 Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta...
Alamat Kantor BCA KCP Santa Telp:0821-8200-233
Telp/WA 62 8218200233 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta...
Alamat BCA KCP Buaran Raya Telp:0821-8200-174
Telp/WA 62 8218200174 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec....
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers