Skip to content

SQL Padawan

"The force is strong with this one"

  • About
  • MSSQLTips
  • Repository

Category: configuration

August 12, 2018 configuration / database / How to / migration / sql server / storage / tools

How to enable stretch database

After the tip https://www.mssqltips.com/sqlservertip/5526/how-to-setup-and-use-a-sql-server-stretch-database/ I made a video to show step by step how to enable stretch database.

May 14, 2018 configuration / database / sql server / storage / tempdb

Moving the msdb, model, and tempdb databases files

All system databases, except the resource database, can be moved to new locations to help balance I/O load. To move

Continue reading

May 10, 2018 configuration / database / parallelism / sql server

Understanding parallelism on SQL Server

Parallelism refers to multiple processors cooperating to execute a single query at the same time. Parallel execution involves the overhead

Continue reading

March 14, 2018 configuration / database / sql server / transaction log

There is insufficient system memory in resource pool

Doing crash and recovery tests on my local machine I got the SQL Server instance not going online. After trying

Continue reading

October 23, 2017 configuration / database / sql server / tools

SQL Examiner Tool

I like tools and I’ve used a couple of them. I had the opportunity to try SQL Examiner to compare

Continue reading

October 12, 2017 best practices / configuration / database / sql server

10 Configurations Best Practices

The first checklist before start using any application using SQL Server should be the default configurations. What configurations I used

Continue reading

  • LinkedIn
  • Twitter
  • Skype
  • Email
  • GitHub
  • YouTube
  • Facebook
My Tweets
March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Nov    

Translate

azure b-tree backup best practices checkpoint configuration database DMV How to index job linux locks migration monitoring powershell replication script sets SQL Operations Studio sql server statistics storage tempdb tools transaction log tsql undocumented wait
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×