For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...

2017-07-03

413 reads

24 Hours of PASS, Summit Preview Session

by kleegeek

Technobabble by Klee from @kleegeek

I’m proud to announce that I’ve been selected to present a session in this year’s 24 Hours of PASS: Summit...

2017-07-03

349 reads

Creating the SSIS Catalog

by Tim Mitchell

Tim Mitchell

If you are building SQL Server Integration Services (SSIS) packages, using the SSIS catalog as a deployment target is usually...

2017-07-03

705 reads

Building Always On Availability Groups - Part 1

by Gethyn Ellis

SQLServerCentral

Introduction
By David Postlethwaite
Ensuring that your databases can survive a major outage such as a server failure and can continue to...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-07-14 (first published: 2017-07-03)

2,194 reads

Monday Coffee: Alerts & Checks

by Andrew Pruski

The DBA Who Came In From The Cold

Hope you all had a good weekend, the Lions won so I’m pretty happy.
Over the weekend I was thinking about...

2017-07-03

358 reads

Update SSMS With PS1

by Sheldon Hull

Sheldon Hull

With how many updates are coming out I threw together a script to parse the latest version from the webpage,...

2017-07-12 (first published: 2017-07-03)

1,627 reads

Capture Important Parameters of the SQL Server Replication

by Dharmendra Keshari

SQL Geek

Whenever there is a business requirement to add a new article to an existing publication, you want to know how...

2017-07-13 (first published: 2017-07-03)

1,702 reads

Security Basics: The Principle of Least Privilege

by Brian Kelley

Databases – Infrastructure – Security

Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...

2017-07-17 (first published: 2017-06-30)

2,957 reads

Don’t Forget the Keys

by Angela

SQL Swimmer

I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server...

2017-07-11 (first published: 2017-06-30)

2,228 reads

Using Organization Hierarchies as Reporting Unit filters with Management Reporter

by terrychoo

Terry's Business Intelligence

Well, hello. It has been more than three years since my last blog, since then I have been really busy...

2017-06-30

586 reads

SQL Homework – July 2017

24 Hours of PASS, Summit Preview Session

Creating the SSIS Catalog

Building Always On Availability Groups - Part 1

Monday Coffee: Alerts & Checks

Update SSMS With PS1

Capture Important Parameters of the SQL Server Replication

Security Basics: The Principle of Least Privilege

Don’t Forget the Keys

Using Organization Hierarchies as Reporting Unit filters with Management Reporter

Blogs

A New Word: Gnossienne

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

Forums

Alamat BCA KCP Dewi Sartika Tlp:08218200233

Alamat Kantor BCA KCP MT Haryono Tlp:08218200203

Alamat BCA KCP Pondok Gede Tlp:08218200174

Question of the Day

The Data API Builder MCP Server Tools