SQL RNNR

Blog Post

Find Index Create Date

This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...

2019-12-25

345 reads

Blog Post

Find Index Create Date

This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...

2019-12-25

4 reads

Blog Post

Ad Hoc Queries Disabled

This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:

Linked Servers and Stats October 17,...

2020-01-02 (first published: )

1,362 reads

Blog Post

Ad Hoc Queries Disabled

This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:

Implicit Conversion Fail May 31, 2019...

2019-12-20

640 reads

Blog Post

When Too Much is Not a Good Thing

Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...

2020-01-06 (first published: )

562 reads

Blog Post

Who needs data access? Not You!

With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:

When Too Much is Not a Good Thing December 13,...

2019-12-30 (first published: )

437 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Are topic notifications working?

By Edward Casbon

This is a topic to test whether reply notifications are working or not.

Connecting ERP system E2 and Extract Data , perform Transformation

By Rahulmsb5

Hello, May someone please help me how can I pull data from ERP named...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers