SQL Server Resources

SQL SERVER Resources

Free Utilities

# Utility #
1 Free Tool – DAX Parameter Replacer and Beautifier

Free online utility to write code

# Utility #
1 Free online utility to write code

SQL Server Interview questions and Answers – Free Download

# Resource #
1 SQL Performance Tuning Articles
2 Excellent Collection of T- SQL Puzzles with Multiple Solutions
3 SQL Server Interview Questions and Answers
4 SSRS Interview Questions and Answers

Free Microsoft E-Books

# Microsoft URL to download Free/Paid E-Books
1 Books Set – 1
2 Books Set – 2
3 Books Set – 3

Free Videos from Microsoft

# Microsoft URL for free videos
1 Microsoft Videos

Blogs I follow-

# Blog
0 SQLSkills Kimberley & Paul
1 SQLBlog.com Adam M
2 SQL CAT Team Microsoft
3 SQL Query Processing Team Microsoft
4 Solid Q Itzik Ben-Gan
5 Craig Freedman’s SQL Server Blog Craig F
6 Benjamin Nevarez Benjamin N
7 Paul White – SQL Server Performance Paul W
8 Paul White – SQL Blog Paul W
9 MSDN – SQL Server Forum SQL Server
11 SQLBI Marco R & Alberto F
12 Microsoft Customer Service and Support (CSS) SQL Support Blog Microsoft
13 SQL Server Premier Field Engineer Blog Microsoft
14 Microsoft SQL Server Tips & Tricks blog Microsoft
15 Microsoft SQL Server Blog Microsoft

1 thought on “SQL Server Resources”

  1. Morgan lee said:

    Hello Buddy,

    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have

    We are running SQL Server 2014 Enterprise Edition hosting Dynamics AX 2012 R3 databases.
    We have some overnight batch processes that are running batch updates but we’re often getting blocking with these queries. The batch processes themselves are blocking a system process with a program name of “TASK MANAGER” with 2 open transactions.
    This seems to be causing the transaction log to fill up because the transaction log backup is unable to clear down the log.
    Having trawled the internet I cannot find a definitive answer as to what the TASK MANAGER process is doing. Some say it’s Change Tracking Cleanup others point to auto stats updates.
    Could someone please advise as to what this system process actually does?

    Anyways, your efforts are much appreciated.

    Thanks a heaps,
    Morgan lee


Leave a comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.