Are you over 18 and want to see adult content?
More Annotations
A complete backup of bugsanimation.com
Are you over 18 and want to see adult content?
A complete backup of papelespintadosromo.com
Are you over 18 and want to see adult content?
A complete backup of waterloo-collection.ru
Are you over 18 and want to see adult content?
A complete backup of lisburncastlereagh.gov.uk
Are you over 18 and want to see adult content?
A complete backup of zusatzeinkommen2u.com
Are you over 18 and want to see adult content?
A complete backup of raisinglifelonglearners.com
Are you over 18 and want to see adult content?
A complete backup of playusalotteries.com
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of www.xhamster.desi
Are you over 18 and want to see adult content?
A complete backup of amateuralbum.net
Are you over 18 and want to see adult content?
A complete backup of thefappening.pro
Are you over 18 and want to see adult content?
A complete backup of www.nerdpervert.com
Are you over 18 and want to see adult content?
A complete backup of www.nakenprat.com
Are you over 18 and want to see adult content?
A complete backup of www.www.zenra.net
Are you over 18 and want to see adult content?
Text
how you
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way. WHICH FILEGROUP IS THAT PARTITION USING? HOW MANY ROWS In-Row GB: Reserved in-row pages for that partition. LOB GB: Reserved LOB pages for that partition (reminder - columnstore indexes use LOB pages) Partition #: This can be useful in some queries. Remember that partition numbers are reassigned when you modify your partition function (split/merge) HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I WHY ROWLOCK HINTS CAN MAKE QUERIES Sometimes when SQL Server gets slow, developers and DBAs find that the problem is blocking. After lots of work to identify the query or queries which are the blockers, frequently one idea is to add ROWLOCK hints to the queries to solve the problem or to disable PAGE locks on the table. This often backfires - here’s why. SLIDING WINDOW TABLE PARTITIONING: WHAT TO DECIDE BEFORE Before you do all the work to map out a complex sliding window table partitioning scheme for your SQL Server tables, here’s the top five questions I’d think through carefully: 1) Do You Need Table Partitioning? Some folks think they need partitioning for performance– but it really shines as a data management feature. Just because you’ve got tables with millions of rows in them doesn WHY IS MY QUERY FASTER THE SECOND TIME IT RUNS? (DEAR SQL 2) It takes time to read data from disk. SQL Server uses memory to cache data in the Buffer Pool so it doesn’t have to go to disk the next time you use that data. There are more reasons that the second run of a query might be faster. The first time you run SHRINKING SQL SERVER DATA FILES I’ve gotten a few questions about shrinking SQL Server data files lately. What’s the best way to get shrink to run? And why might it fail in some cases? Traditionally, every time you ask a DBA how to make shrinking suck less, they start ranting how shrinking is bad and you just shouldn’t do it. Sometimes it sounds kinda angry. What people are trying to say is that shrinking data files is HOW TO CHOOSE BETWEEN RCSI AND SNAPSHOT ISOLATION LEVELS SQL Server offers two flavors of optimistic locking for traditional disk-based tables: Read Committed Snapshot Isolation (RCSI), and Snapshot Isolation. They are each great tools to reduce blocking and make applications faster, particularly in databases that have lots of tiny reads and writes that need to be quick, or mixed-use patterns (lots of little reads and writes + larger reporting queries). LITTLEKENDRA.COMLITTLEKENDRA.COMHEADSETPERSONFREE TRAININGSQLCHALLENGESLOCKING sketchnotes. Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach. While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas onhow you
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way. WHICH FILEGROUP IS THAT PARTITION USING? HOW MANY ROWS In-Row GB: Reserved in-row pages for that partition. LOB GB: Reserved LOB pages for that partition (reminder - columnstore indexes use LOB pages) Partition #: This can be useful in some queries. Remember that partition numbers are reassigned when you modify your partition function (split/merge) HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I WHY ROWLOCK HINTS CAN MAKE QUERIES Sometimes when SQL Server gets slow, developers and DBAs find that the problem is blocking. After lots of work to identify the query or queries which are the blockers, frequently one idea is to add ROWLOCK hints to the queries to solve the problem or to disable PAGE locks on the table. This often backfires - here’s why. SLIDING WINDOW TABLE PARTITIONING: WHAT TO DECIDE BEFORE Before you do all the work to map out a complex sliding window table partitioning scheme for your SQL Server tables, here’s the top five questions I’d think through carefully: 1) Do You Need Table Partitioning? Some folks think they need partitioning for performance– but it really shines as a data management feature. Just because you’ve got tables with millions of rows in them doesn WHY IS MY QUERY FASTER THE SECOND TIME IT RUNS? (DEAR SQL 2) It takes time to read data from disk. SQL Server uses memory to cache data in the Buffer Pool so it doesn’t have to go to disk the next time you use that data. There are more reasons that the second run of a query might be faster. The first time you run SHRINKING SQL SERVER DATA FILES I’ve gotten a few questions about shrinking SQL Server data files lately. What’s the best way to get shrink to run? And why might it fail in some cases? Traditionally, every time you ask a DBA how to make shrinking suck less, they start ranting how shrinking is bad and you just shouldn’t do it. Sometimes it sounds kinda angry. What people are trying to say is that shrinking data files is HOW TO CHOOSE BETWEEN RCSI AND SNAPSHOT ISOLATION LEVELS SQL Server offers two flavors of optimistic locking for traditional disk-based tables: Read Committed Snapshot Isolation (RCSI), and Snapshot Isolation. They are each great tools to reduce blocking and make applications faster, particularly in databases that have lots of tiny reads and writes that need to be quick, or mixed-use patterns (lots of little reads and writes + larger reporting queries).LITTLEKENDRA.COM
Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach.. While this is an internal conference, I can share my drawings and notes from sessions Iattended.
TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. INDEX CREATE AND LAST MODIFIED DATES IN SQL SERVER In many environments, it’s useful to know exactly when an index was created or modified. Did that last code release help performance, or hurt it? It’s really helpful to know exactly when the code was deployed to prove that your change made something better. Or that you might need to roll it back. It takes a little preparation to track changes to your indexes, but it’s easy to implement. WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIR This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task SHRINKING SQL SERVER DATA FILES I’ve gotten a few questions about shrinking SQL Server data files lately. What’s the best way to get shrink to run? And why might it fail in some cases? Traditionally, every time you ask a DBA how to make shrinking suck less, they start ranting how shrinking is bad and you just shouldn’t do it. Sometimes it sounds kinda angry. What people are trying to say is that shrinking data files is WHY YOU SHOULD SWITCH IN STAGING TABLES INSTEAD OF Over the years, I’ve come across a pattern fairly frequently: an application in an OLTP database periodically creates new tables, loads some data into them and fixes it up, then does a switcheroo and replaces old tables with the new tables. This can cause major problems with blocking if anyone else is querying the table. SHOULD I AUTOMATE MY WINDOWS UPDATES FOR SQL SERVER? (DEAR Fully automated patching. Manual verification that things look normal after the patching before patches are cleared for production SQL Servers. Non-Critical Production SQL Servers - prize cattle that compete at the county fair. Can be down for 2+ hours during a WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. LITTLEKENDRA.COMLITTLEKENDRA.COMHEADSETPERSONFREE TRAININGSQLCHALLENGESLOCKING sketchnotes. Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach. While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas onhow you
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way. WHICH FILEGROUP IS THAT PARTITION USING? HOW MANY ROWS In-Row GB: Reserved in-row pages for that partition. LOB GB: Reserved LOB pages for that partition (reminder - columnstore indexes use LOB pages) Partition #: This can be useful in some queries. Remember that partition numbers are reassigned when you modify your partition function (split/merge) WHY ROWLOCK HINTS CAN MAKE QUERIES Sometimes when SQL Server gets slow, developers and DBAs find that the problem is blocking. After lots of work to identify the query or queries which are the blockers, frequently one idea is to add ROWLOCK hints to the queries to solve the problem or to disable PAGE locks on the table. This often backfires - here’s why. HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I SLIDING WINDOW TABLE PARTITIONING: WHAT TO DECIDE BEFORE Before you do all the work to map out a complex sliding window table partitioning scheme for your SQL Server tables, here’s the top five questions I’d think through carefully: 1) Do You Need Table Partitioning? Some folks think they need partitioning for performance– but it really shines as a data management feature. Just because you’ve got tables with millions of rows in them doesn WHY IS MY QUERY FASTER THE SECOND TIME IT RUNS? (DEAR SQL 2) It takes time to read data from disk. SQL Server uses memory to cache data in the Buffer Pool so it doesn’t have to go to disk the next time you use that data. There are more reasons that the second run of a query might be faster. The first time you run HOW TO CHOOSE BETWEEN RCSI AND SNAPSHOT ISOLATION LEVELS SQL Server offers two flavors of optimistic locking for traditional disk-based tables: Read Committed Snapshot Isolation (RCSI), and Snapshot Isolation. They are each great tools to reduce blocking and make applications faster, particularly in databases that have lots of tiny reads and writes that need to be quick, or mixed-use patterns (lots of little reads and writes + larger reporting queries). SHRINKING SQL SERVER DATA FILES I’ve gotten a few questions about shrinking SQL Server data files lately. What’s the best way to get shrink to run? And why might it fail in some cases? Traditionally, every time you ask a DBA how to make shrinking suck less, they start ranting how shrinking is bad and you just shouldn’t do it. Sometimes it sounds kinda angry. What people are trying to say is that shrinking data files is LITTLEKENDRA.COMLITTLEKENDRA.COMHEADSETPERSONFREE TRAININGSQLCHALLENGESLOCKING sketchnotes. Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach. While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas onhow you
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way. WHICH FILEGROUP IS THAT PARTITION USING? HOW MANY ROWS In-Row GB: Reserved in-row pages for that partition. LOB GB: Reserved LOB pages for that partition (reminder - columnstore indexes use LOB pages) Partition #: This can be useful in some queries. Remember that partition numbers are reassigned when you modify your partition function (split/merge) WHY ROWLOCK HINTS CAN MAKE QUERIES Sometimes when SQL Server gets slow, developers and DBAs find that the problem is blocking. After lots of work to identify the query or queries which are the blockers, frequently one idea is to add ROWLOCK hints to the queries to solve the problem or to disable PAGE locks on the table. This often backfires - here’s why. HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I SLIDING WINDOW TABLE PARTITIONING: WHAT TO DECIDE BEFORE Before you do all the work to map out a complex sliding window table partitioning scheme for your SQL Server tables, here’s the top five questions I’d think through carefully: 1) Do You Need Table Partitioning? Some folks think they need partitioning for performance– but it really shines as a data management feature. Just because you’ve got tables with millions of rows in them doesn WHY IS MY QUERY FASTER THE SECOND TIME IT RUNS? (DEAR SQL 2) It takes time to read data from disk. SQL Server uses memory to cache data in the Buffer Pool so it doesn’t have to go to disk the next time you use that data. There are more reasons that the second run of a query might be faster. The first time you run HOW TO CHOOSE BETWEEN RCSI AND SNAPSHOT ISOLATION LEVELS SQL Server offers two flavors of optimistic locking for traditional disk-based tables: Read Committed Snapshot Isolation (RCSI), and Snapshot Isolation. They are each great tools to reduce blocking and make applications faster, particularly in databases that have lots of tiny reads and writes that need to be quick, or mixed-use patterns (lots of little reads and writes + larger reporting queries). SHRINKING SQL SERVER DATA FILES I’ve gotten a few questions about shrinking SQL Server data files lately. What’s the best way to get shrink to run? And why might it fail in some cases? Traditionally, every time you ask a DBA how to make shrinking suck less, they start ranting how shrinking is bad and you just shouldn’t do it. Sometimes it sounds kinda angry. What people are trying to say is that shrinking data files isLITTLEKENDRA.COM
Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach.. While this is an internal conference, I can share my drawings and notes from sessions Iattended.
TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I INDEX CREATE AND LAST MODIFIED DATES IN SQL SERVER In many environments, it’s useful to know exactly when an index was created or modified. Did that last code release help performance, or hurt it? It’s really helpful to know exactly when the code was deployed to prove that your change made something better. Or that you might need to roll it back. It takes a little preparation to track changes to your indexes, but it’s easy to implement. WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIR This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task SHOULD I AUTOMATE MY WINDOWS UPDATES FOR SQL SERVER? (DEAR Fully automated patching. Manual verification that things look normal after the patching before patches are cleared for production SQL Servers. Non-Critical Production SQL Servers - prize cattle that compete at the county fair. Can be down for 2+ hours during a SHOULD YOU REBUILD OR REORGANIZE INDEXES ON LARGE TABLES The bigger your indexes are, the harder your index maintenance falls. Is it better to rebuild big indexes? Or should you reorganize? If you’re short on time, scroll down: an article with all the content is below the 23 minute video. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. SQL AGENT JOBS: CHECKING FOR FAILED STEPS AT THE END OF A At the end of the job the final step checks see if any previous step in the current run has failed. If so, it fails the job itself, otherwise the job will succeed. The last step should list all the steps that have failed, just for ease of use. So far this is working in my tests as the code for the final step, and it meets my needs forthis type
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way.TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIR This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working on TRAINING PLAN FOR JUNIOR DBAS LEARNING SQL SERVER You’re just getting started as a SQL Server Database Administrator – or you’re trying to get there. Here’s a learning plan and links to free articles and scripts that will equip you to tackle the three most critical skills to for DBAs. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. FINDING QUERIES THAT CAUSE WAIT STATS IN SQL SERVER THREADPOOL waits. This is a wait associated with not having enough threads - it means there’s a lot of active processes, so many that the SQL Server can’t make more threads without risking stability of the OS. This can be associated with problems in connection pooling, or sometimes it happens with some applications if you get a lot of AVERAGE DAILY JOB RUNTIME Here’s a query I found useful today– this week we moved many of our production datamart servers to SQL 2K5 SP3 CU4, and today among the course of other issues I wanted to take a look at my job runtimes to see if they might be noticeably slower or faster than prior runs. I often am in a similar situation after deploying significant changes toour codebase.
SQL 2008 AGENT JOBS
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way.TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIR This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working on TRAINING PLAN FOR JUNIOR DBAS LEARNING SQL SERVER You’re just getting started as a SQL Server Database Administrator – or you’re trying to get there. Here’s a learning plan and links to free articles and scripts that will equip you to tackle the three most critical skills to for DBAs. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. FINDING QUERIES THAT CAUSE WAIT STATS IN SQL SERVER THREADPOOL waits. This is a wait associated with not having enough threads - it means there’s a lot of active processes, so many that the SQL Server can’t make more threads without risking stability of the OS. This can be associated with problems in connection pooling, or sometimes it happens with some applications if you get a lot of AVERAGE DAILY JOB RUNTIME Here’s a query I found useful today– this week we moved many of our production datamart servers to SQL 2K5 SP3 CU4, and today among the course of other issues I wanted to take a look at my job runtimes to see if they might be noticeably slower or faster than prior runs. I often am in a similar situation after deploying significant changes toour codebase.
SQL 2008 AGENT JOBS
LITTLEKENDRA.COM
sketchnotes. Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach. While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas onhow you
TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. ADMINISTERING COTS DATABASES (ISVS / THIRD PARTY VENDORS Administering COTS databases (ISVs / Third Party Vendors) 2017-01-10. sql. I recently received a question from a vendor about databases created by software vendors. I just moved from an in-house software development company to a new environment that most of the software used here are COTS (Commercial off-the-shelf) This is totally new tome.
WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I AVERAGE DAILY JOB RUNTIME Here’s a query I found useful today– this week we moved many of our production datamart servers to SQL 2K5 SP3 CU4, and today among the course of other issues I wanted to take a look at my job runtimes to see if they might be noticeably slower or faster than prior runs. I often am in a similar situation after deploying significant changes toour codebase.
FINDING QUERIES THAT CAUSE WAIT STATS IN SQL SERVER THREADPOOL waits. This is a wait associated with not having enough threads - it means there’s a lot of active processes, so many that the SQL Server can’t make more threads without risking stability of the OS. This can be associated with problems in connection pooling, or sometimes it happens with some applications if you get a lot of CHANGE DATA CAPTURE VS CHANGE TRACKING Change Tracking (CT) Change Tracking is a synchronous mechanism which modifies change tracking tables as part of ongoing transactions to indicate when a row has been changed. It does not record past or intermediate versions of the data itself, only that a change has occurred. It is recommended to use snapshot isolation with ChangeTracking!
SQL 2008 AGENT JOBS
I have been working away building out servers in our new prod test environment, and automating as much as possible along the way with PowerShell. I have to say that it’s been really fun and PoSH has brought back that loving feeling that I always had for Perl. If a programming language can be friendly, PowerShell manages it. HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way.TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIR This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working on TRAINING PLAN FOR JUNIOR DBAS LEARNING SQL SERVER You’re just getting started as a SQL Server Database Administrator – or you’re trying to get there. Here’s a learning plan and links to free articles and scripts that will equip you to tackle the three most critical skills to for DBAs. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. FINDING QUERIES THAT CAUSE WAIT STATS IN SQL SERVER THREADPOOL waits. This is a wait associated with not having enough threads - it means there’s a lot of active processes, so many that the SQL Server can’t make more threads without risking stability of the OS. This can be associated with problems in connection pooling, or sometimes it happens with some applications if you get a lot of AVERAGE DAILY JOB RUNTIME Here’s a query I found useful today– this week we moved many of our production datamart servers to SQL 2K5 SP3 CU4, and today among the course of other issues I wanted to take a look at my job runtimes to see if they might be noticeably slower or faster than prior runs. I often am in a similar situation after deploying significant changes toour codebase.
SQL 2008 AGENT JOBS
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and Enterprise Edition. Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way.TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIR This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working on TRAINING PLAN FOR JUNIOR DBAS LEARNING SQL SERVER You’re just getting started as a SQL Server Database Administrator – or you’re trying to get there. Here’s a learning plan and links to free articles and scripts that will equip you to tackle the three most critical skills to for DBAs. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. FINDING QUERIES THAT CAUSE WAIT STATS IN SQL SERVER THREADPOOL waits. This is a wait associated with not having enough threads - it means there’s a lot of active processes, so many that the SQL Server can’t make more threads without risking stability of the OS. This can be associated with problems in connection pooling, or sometimes it happens with some applications if you get a lot of AVERAGE DAILY JOB RUNTIME Here’s a query I found useful today– this week we moved many of our production datamart servers to SQL 2K5 SP3 CU4, and today among the course of other issues I wanted to take a look at my job runtimes to see if they might be noticeably slower or faster than prior runs. I often am in a similar situation after deploying significant changes toour codebase.
SQL 2008 AGENT JOBS
LITTLEKENDRA.COM
sketchnotes. Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach. While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas onhow you
TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. ADMINISTERING COTS DATABASES (ISVS / THIRD PARTY VENDORS Administering COTS databases (ISVs / Third Party Vendors) 2017-01-10. sql. I recently received a question from a vendor about databases created by software vendors. I just moved from an in-house software development company to a new environment that most of the software used here are COTS (Commercial off-the-shelf) This is totally new tome.
WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I AVERAGE DAILY JOB RUNTIME Here’s a query I found useful today– this week we moved many of our production datamart servers to SQL 2K5 SP3 CU4, and today among the course of other issues I wanted to take a look at my job runtimes to see if they might be noticeably slower or faster than prior runs. I often am in a similar situation after deploying significant changes toour codebase.
FINDING QUERIES THAT CAUSE WAIT STATS IN SQL SERVER THREADPOOL waits. This is a wait associated with not having enough threads - it means there’s a lot of active processes, so many that the SQL Server can’t make more threads without risking stability of the OS. This can be associated with problems in connection pooling, or sometimes it happens with some applications if you get a lot of CHANGE DATA CAPTURE VS CHANGE TRACKING Change Tracking (CT) Change Tracking is a synchronous mechanism which modifies change tracking tables as part of ongoing transactions to indicate when a row has been changed. It does not record past or intermediate versions of the data itself, only that a change has occurred. It is recommended to use snapshot isolation with ChangeTracking!
SQL 2008 AGENT JOBS
I have been working away building out servers in our new prod test environment, and automating as much as possible along the way with PowerShell. I have to say that it’s been really fun and PoSH has brought back that loving feeling that I always had for Perl. If a programming language can be friendly, PowerShell manages it.TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if TROUBLESHOOTING BLOCKING AND DEADLOCKS FOR BEGINNERS (2 Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes) Your SQL Server is slow, and you suspect blocking. Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks. You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools andscripts to
TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIRSQL SERVER DATABASE SPACE AVAILABLESQL SERVER DATABASE SPACE USEDSQL SERVER DISK SPACE USAGESQL SERVER SPACE FUNCTIONSQL SERVER SPACE USAGESQL SERVERSPACE USAGE
This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCETABLE PARTITIONING IN SQL SERVERSQL SERVER TABLE PARTITION QUERYTABLE PARTITION IN SQL SERVERTABLE PARTITION IN SQL SERVER Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working onTABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if TROUBLESHOOTING BLOCKING AND DEADLOCKS FOR BEGINNERS (2 Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes) Your SQL Server is slow, and you suspect blocking. Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks. You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools andscripts to
TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIRSQL SERVER DATABASE SPACE AVAILABLESQL SERVER DATABASE SPACE USEDSQL SERVER DISK SPACE USAGESQL SERVER SPACE FUNCTIONSQL SERVER SPACE USAGESQL SERVERSPACE USAGE
This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCETABLE PARTITIONING IN SQL SERVERSQL SERVER TABLE PARTITION QUERYTABLE PARTITION IN SQL SERVERTABLE PARTITION IN SQL SERVER Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working onLITTLEKENDRA.COM
sketchnotes. Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach. While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas onhow you
MANAGING DRIFT IN AUTOMATED DEPLOYMENTS TO SQL SERVER One big gotcha that teams often encounter when automating deployments for databases is that it’s difficult– or sometimes impossible – to ensure that all changes to the production database are performed through the automation pipeline.TABLE-PARTITIONING
You’re designing table partitioning, or you want to make a change to an existing partition function. It’s critical to understand the difference between how “left” and “right” partition functions behave, but the documentation is a bit confusing on this topic. TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. USE CHOCOLATEY TO INSTALL MULTIPLE SQL SERVER 2019 To make this easier, I’m using: Octopus Deploy Runbooks to organize a series of commands (they have a free tier, FYI) Chocolatey to install multiple SQL Server 2019 Developer Edition instances (I’ve written about choco before, it’s also free) While I’m not at all a fan of “stacking” multiple SQL Server Instances into one Windows WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. WHICH FILEGROUP IS THAT PARTITION USING? HOW MANY ROWS In-Row GB: Reserved in-row pages for that partition. LOB GB: Reserved LOB pages for that partition (reminder - columnstore indexes use LOB pages) Partition #: This can be useful in some queries. Remember that partition numbers are reassigned when you modify your partition function (split/merge) SPLIT IN A LEFT PARTITION FUNCTION: WHERE DOES THE ABOVE Table partitioning seems simple, but there’s a lot of complexity in designing and managing it if you decide to use filegroups and splitting. When you first implement partitioning in this scenario, you decide where you’re going to keep “out of bound” data when you create your partition scheme. Be careful when you make that decision, because it may not be easy to change later. 3 WAYS AVAILABILITY GROUPS BEAT DATABASE MIRRORING 3 Ways Availability Groups Beat Database Mirroring. 1. The Listener is Way Better than Ye Olde Failover Partner Connection String. 2. Third Party Monitoring Tools are Better than Hacked Alerts. 3. The AlwaysOn-Health XE Session is Better than.TABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if TROUBLESHOOTING BLOCKING AND DEADLOCKS FOR BEGINNERS (2 Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes) Your SQL Server is slow, and you suspect blocking. Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks. You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools andscripts to
TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIRSQL SERVER DATABASE SPACE AVAILABLESQL SERVER DATABASE SPACE USEDSQL SERVER DISK SPACE USAGESQL SERVER SPACE FUNCTIONSQL SERVER SPACE USAGESQL SERVERSPACE USAGE
This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCETABLE PARTITIONING IN SQL SERVERSQL SERVER TABLE PARTITION QUERYTABLE PARTITION IN SQL SERVERTABLE PARTITION IN SQL SERVER Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working onTABLE-PARTITIONING
Truncate Table with Partitions Fails if You Have Non-Aligned Indexes. 2016-03-22. sql. SQL Server 2016 brought in a cool new little feature for table partitioning: you can now truncate individual partitions. There’s one little gotcha, though: you can only do this if TROUBLESHOOTING BLOCKING AND DEADLOCKS FOR BEGINNERS (2 Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes) Your SQL Server is slow, and you suspect blocking. Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks. You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools andscripts to
TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. WHICH INDEXES ARE "DISK BASED" IN SQL Columnstore indexes are also disk based. Updatable Columnstore indexes use special rowstore B-trees behind the scenes. And Books Online says “rowstore” also refers to Memory-Optimized tables. Here’s a drawing that maps out what is disk based vs in-memory, followed by a list with links to some of the details. Words are Hard! WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIRSQL SERVER DATABASE SPACE AVAILABLESQL SERVER DATABASE SPACE USEDSQL SERVER DISK SPACE USAGESQL SERVER SPACE FUNCTIONSQL SERVER SPACE USAGESQL SERVERSPACE USAGE
This script comes in handy more frequently than I would have thought before I started using it. This script returns space used in tempdb only, regardless of the db context it’s run in, and it only works for tempdb. I adapted this from the SQL Server Storage Engine Blog. select t1.session_id , t1.request_id , task_alloc_GB = cast( (t1.task HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCETABLE PARTITIONING IN SQL SERVERSQL SERVER TABLE PARTITION QUERYTABLE PARTITION IN SQL SERVERTABLE PARTITION IN SQL SERVER Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working onLITTLEKENDRA.COM
sketchnotes. Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach. While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas onhow you
MANAGING DRIFT IN AUTOMATED DEPLOYMENTS TO SQL SERVER One big gotcha that teams often encounter when automating deployments for databases is that it’s difficult– or sometimes impossible – to ensure that all changes to the production database are performed through the automation pipeline.TABLE-PARTITIONING
You’re designing table partitioning, or you want to make a change to an existing partition function. It’s critical to understand the difference between how “left” and “right” partition functions behave, but the documentation is a bit confusing on this topic. TSQL FOR BEGINNERS (REDGATE UNIVERSITY) TSQL for Beginners (Redgate University) This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements. The course contains 8 classes with more than 7.5 hours of video content. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. USE CHOCOLATEY TO INSTALL MULTIPLE SQL SERVER 2019 To make this easier, I’m using: Octopus Deploy Runbooks to organize a series of commands (they have a free tier, FYI) Chocolatey to install multiple SQL Server 2019 Developer Edition instances (I’ve written about choco before, it’s also free) While I’m not at all a fan of “stacking” multiple SQL Server Instances into one Windows WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. WHICH FILEGROUP IS THAT PARTITION USING? HOW MANY ROWS In-Row GB: Reserved in-row pages for that partition. LOB GB: Reserved LOB pages for that partition (reminder - columnstore indexes use LOB pages) Partition #: This can be useful in some queries. Remember that partition numbers are reassigned when you modify your partition function (split/merge) SPLIT IN A LEFT PARTITION FUNCTION: WHERE DOES THE ABOVE Table partitioning seems simple, but there’s a lot of complexity in designing and managing it if you decide to use filegroups and splitting. When you first implement partitioning in this scenario, you decide where you’re going to keep “out of bound” data when you create your partition scheme. Be careful when you make that decision, because it may not be easy to change later. 3 WAYS AVAILABILITY GROUPS BEAT DATABASE MIRRORING 3 Ways Availability Groups Beat Database Mirroring. 1. The Listener is Way Better than Ye Olde Failover Partner Connection String. 2. Third Party Monitoring Tools are Better than Hacked Alerts. 3. The AlwaysOn-Health XE Session is Better than.TABLE-PARTITIONING
You’re designing table partitioning, or you want to make a change to an existing partition function. It’s critical to understand the difference between how “left” and “right” partition functions behave, but the documentation is a bit confusing on this topic. TROUBLESHOOTING BLOCKING AND DEADLOCKS FOR BEGINNERS (2 Your SQL Server is slow, and you suspect blocking. Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools and scripts to SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. WHICH INDEXES ARE "DISK BASED" IN SQL I was looking through some terms in SQL Server documentation the other day, thinking about what it’s like to learn about SQL Server’s indexes when you’re new to the field. I jotted down a note: B-tree = Rowstore = Disk Based. And then I realized that’s not quite right. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER What’s batch mode? Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working on individual rows. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCETABLE PARTITIONING IN SQL SERVERSQL SERVER TABLE PARTITION QUERYTABLE PARTITION IN SQL SERVERTABLE PARTITION IN SQL SERVER Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIRSQL SERVER DATABASE SPACE AVAILABLESQL SERVER DATABASE SPACE USEDSQL SERVER DISK SPACE USAGESQL SERVER SPACE FUNCTIONSQL SERVER SPACE USAGESQL SERVERSPACE USAGE
Sometimes tempdb is filling up. Sometimes I just want to monitor the amount of tempdb and check out execution plans of heavy tempdb users while watching performance on a server. WHY IS MY QUERY FASTER THE SECOND TIME IT RUNS? (DEAR SQL Today’s question is about why a query might be slow at first, then fast the next time you run it. Watch the 26 minute video or scroll on down and read the written version of the episode instead.TABLE-PARTITIONING
You’re designing table partitioning, or you want to make a change to an existing partition function. It’s critical to understand the difference between how “left” and “right” partition functions behave, but the documentation is a bit confusing on this topic. TROUBLESHOOTING BLOCKING AND DEADLOCKS FOR BEGINNERS (2 Your SQL Server is slow, and you suspect blocking. Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools and scripts to SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. WHICH INDEXES ARE "DISK BASED" IN SQL I was looking through some terms in SQL Server documentation the other day, thinking about what it’s like to learn about SQL Server’s indexes when you’re new to the field. I jotted down a note: B-tree = Rowstore = Disk Based. And then I realized that’s not quite right. HOW TO SCRIPT OUT INDEXES FROM SQL SERVER Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!) Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I HOW TO CHECK IF AN INDEX EXISTS ON A TABLE IN SQL SERVER These both do 2 logical reads and are very fast. Option 2: Query sys.indexes, sys.objects, and sys.schemas (Fewer Locks) If you want to avoid the SCH_S lock against the table whose indexes you’re checking for some reason, you just need a couple more joins. BATCH MODE HACKS FOR ROWSTORE QUERIES IN SQL SERVER What’s batch mode? Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks. Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working on individual rows. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCETABLE PARTITIONING IN SQL SERVERSQL SERVER TABLE PARTITION QUERYTABLE PARTITION IN SQL SERVERTABLE PARTITION IN SQL SERVER Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. WHO'S USING ALL THAT SPACE IN TEMPDB, AND WHAT'S THEIRSQL SERVER DATABASE SPACE AVAILABLESQL SERVER DATABASE SPACE USEDSQL SERVER DISK SPACE USAGESQL SERVER SPACE FUNCTIONSQL SERVER SPACE USAGESQL SERVERSPACE USAGE
Sometimes tempdb is filling up. Sometimes I just want to monitor the amount of tempdb and check out execution plans of heavy tempdb users while watching performance on a server. WHY IS MY QUERY FASTER THE SECOND TIME IT RUNS? (DEAR SQL Today’s question is about why a query might be slow at first, then fast the next time you run it. Watch the 26 minute video or scroll on down and read the written version of the episode instead.LITTLEKENDRA.COM
Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach.. While this is an internal conference, I can share my drawings and notes from sessions Iattended.
MANAGING DRIFT IN AUTOMATED DEPLOYMENTS TO SQL SERVER One big gotcha that teams often encounter when automating deployments for databases is that it’s difficult– or sometimes impossible – to ensure that all changes to the production database are performed through the automation pipeline.TABLE-PARTITIONING
You’re designing table partitioning, or you want to make a change to an existing partition function. It’s critical to understand the difference between how “left” and “right” partition functions behave, but the documentation is a bit confusing on this topic. TSQL FOR BEGINNERS (REDGATE UNIVERSITY) Kendra is an American living in the UK. She is a product manager and a database nerd who carries on long conversations with her pets. SETTING A CUSTOM VARIABLE IN AN AZURE DEVOPS PIPELINE WITH Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way. Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem. USE CHOCOLATEY TO INSTALL MULTIPLE SQL SERVER 2019 I’m working on a project where it’s useful to automate environment setup and teardown for testing some devops deployment scenarios for databases using transactional replication. WHY TABLE PARTITIONING DOESN'T SPEED UP QUERY PERFORMANCE Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower. In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems. WHICH FILEGROUP IS THAT PARTITION USING? HOW MANY ROWS Kendra is an American living in the UK. She is a product manager and a database nerd who carries on long conversations with her pets. SPLIT IN A LEFT PARTITION FUNCTION: WHERE DOES THE ABOVE Table partitioning seems simple, but there’s a lot of complexity in designing and managing it if you decide to use filegroups and splitting. When you first implement partitioning in this scenario, you decide where you’re going to keep “out of bound” data when you create your partition scheme. Be careful when you make that decision, because it may not be easy to change later. 3 WAYS AVAILABILITY GROUPS BEAT DATABASE MIRRORING SQL Server Availability Groups are growing up. SQL Server 2016 adds more features and improvements, and these include options to run SQL Server in different domains, or without a domain.. That brings Availability Groups closer to feature parity with Database Mirroringin SQL Server 2016.
LittleKendra.com
Kendra Little's blog about SQL Server and database devops Menu* blog
* free courses ▾
* Database Administration* Indexing
* Locking & blocking* Partitioning
* Query Tuning
* SQL Challenges
* SSMS
* tsql
* All courses by date* About
* Contact
* Podcast
* Subscribe
MANAGING DRIFT IN AUTOMATED DEPLOYMENTS TO SQL SERVER DATABASES2021-06-04
devops , sql
One big gotcha that teams often encounter when automating deployments for databases is that it’s difficult– or sometimes impossible – to ensure that all changes to the production database are performed through the automation pipeline. These out-of-band changes case the production database to “drift” away from the schema as defined in version control. WHY NOSQL DATABASE ADOPTION ISN'T A ONE WAY JOURNEY2021-05-27
NoSQL
A coworker shared with me recently that a customer is wholly investing in adopting non-relational datastores. “Is NoSQL taking over?” they asked. MY SKETCHNOTES FROM REDGATE'S LEVEL UP WEEK 20212021-05-24
sketchnotes
Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach.
While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas on how you can contribute to learning in your own organization – or perhaps simply inspire you to give sketchnoting a try. AZURE STATIC WEB APPS ARE NOW GENERALLY AVAILABLE2021-05-18
Blogging
I wrote recently about moving my blog from Wordpress to an AzureStatic Site
.
Azure Static Web Apps have now moved out of Preview and are now generally available. A free tier has been announced which is great forpersonal blogs.
MAINTAINING BALANCE WHILE RETRAINING IN A NEW PROFESSIONAL AREA2021-05-10
Mental Health
It’s common to shift your professional focus multiple times over your career while working in tech. But moving into a new role often causes a lot of stress. In my recent lightning talk for Mental Health and Awareness Day,
I reflected on the lessons I’ve learned to set myself up for success and protect my health when taking on a new professional challenge. HOW I GOT TWITTER CARDS WORKING IN HUGO WITH THE MAINROAD THEME2021-05-07
Blogging
Hugo now has native support for Twitter Cards, but it took a few steps to get them working on my site in the way I wanted. Here’s how I configured Twitter Cards in Hugo without any newshortcodes.
HOW TO ENABLE TCP/IP IN SQL SERVER DEVELOPER EDITION, EVEN IF THE CONFIGURATION MANAGER IS MISSING2021-05-05
SQL Server
SQL Server’s Developer Edition installs with a different default network protocol configuration than Standard Edition and EnterpriseEdition.
Fixing this has gotten more complicated because it’s become common for the SQL Server Configuration Manager to not be installed on a developer’s workstation in an easily accessible way. MOVING FROM WORDPRESS TO AN AZURE STATIC SITE WITH HUGO2021-05-03
Blogging
I’ve moved from WordPress to an Azure Static website built with Hugo. The conversion, including grooming all my old posts and a special setup for my free courses took up most of my personal time for a week (including a 4 day weekend). Here’s why I made the change. I’ll also share the basic components I chose for my site, the tools and steps I used in the conversion, and some lessons learned from the implementation. HELP ME NOT BE SELECTED TO SPEAK AT THE DATIVERSE VIRTUAL CONFERENCE2021-04-22
sql
A call for speakers is open for the very first edition of the Dativerse conference, which will be held on August 13, 2021: http://dativerse.io/ FREE VIRTUAL EVENT: MENTAL HEALTH AND AWARENESS DAY ON MAY 7TH2021-04-21
sql
I’ll be giving a 10 minute lightning talk at the upcoming Mental Health and Wellness day eventon May 7,
2021, hosted by the Data Platform WIT group. TEN IDEAS TO IMPROVE ONLINE TECH CONFERENCES2020-11-18
sql
Amid the global pandemic, online tech conferences have had a natural surge in popularity. I’ve attended quite a few of these in 2020 across several technical areas (database tech, DevOps, privacy, tech research). The conferences have been both large and small, both free and paid, and have been held across a few different regions and timezones.
COPING WITH THE PANDEMIC (T-SQL TUESDAY #132)2020-11-10
sql
This post is part of the monthly TSQLTuesday blog event. This month’s topic is from Taiob Ali. Taiob asks how are we coping amid the pandemic.
DOWN TOOLS WEEK 2020 (10 MINUTE VIDEO/PODCAST EPISODE)2020-08-06
sql
It’s Down Tools Week at Redgate . In this episode, I share what “Down Tools Week” is, what I’m working on this week, and why I think it’s a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization. THINGS THAT SHOULDN'T BE NORMAL IN DATABASE DEVELOPMENT (28 MINUTE VIDEO/PODCAST EPISODE)2020-07-30
sql
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development– but which are incredibly common. EVERYTHING I NEVER WANTED TO KNOW ABOUT COLLATION (14 MINUTE VIDEO/PODCAST EPISODE)2020-07-16
dear-sql-dba
I’m not an expert on collation in SQL Server, but there are a few important facts which I’ve had to learn the hard way. In this episode I share the basics, along with helpful resources to learnmore.
HOW TO SPELL AND CAPITALIZE TEMPDB FOR SQL SERVER2020-07-15
sql
No matter what I write in this post, some of y’all are going to tell me I’m wrong. That’s inevitable, because I’m writing about tempdb: a database so complex and mysterious in SQL Server, that even the spelling and capitalization of the database name is a topic of great disagreement. Note: nearly everyone has been inconsistent about this You might think, “This is easy, just check Microsoft’s documentation to find the answer. THE MANAGER'S GUIDE TO GIT TRAINING FOR DBAS (VIDEO / PODCAST)2020-07-09
sql
Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful. THOUGHTS AS PRIDE MONTH 2020 COMES TO A CLOSE2020-06-30
sql
I’ve begun working on developing a couple of small habits this month, thanks largely to Andy Mallon ’shelpful advocacy.
NEW FREE COURSE: THE DIRTY SECRETS OF NOLOCK2020-06-29
sql
I’m excited to begin moving over courses from SQL Workbooks and making the material available here. The first course up for grabs is The Dirty Secrets of NOLOCK . HOW TO "RENAME" THE MASTER BRANCH TO MAIN IN GIT IN AZURE DEVOPS2020-06-26
devops
I believe that language matters, and that it is worth our effort to move away from language associated with slavery and racism wheneverpossible
.
1/26 »
SOCIAL
🤓 GitHub
📺 Youtube
📢 Sessionize
📡 RSS
RECENT POSTS
* Managing Drift in Automated Deployments to SQL Server Databases * Why NoSQL Database Adoption isn't a One Way Journey * My Sketchnotes from Redgate's Level Up Week 2021 * Azure Static Web Apps Are Now Generally Available * Maintaining Balance While Retraining in a New Professional Area * How I Got Twitter Cards Working in Hugo with the Mainroad theme * How to Enable TCP/IP in SQL Server Developer Edition, even if the Configuration Manager is Missing 2021 Kendra Little. Generated with Hugo andMainroad theme.
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0