- SSMS Unuseful Tips
- Why Database Continuous Integration is Challenging?
- Monitoring Page Splits
Today in the show:
- Guy is back from Nepal
- The GTD method for productivity
- The future of DBA work (Data Engineering and Database Reliability Engineering)
- Threadpool waits
- Getting used to learning new things
- Good old Implicit_Conversion
- And more..
In this show, we talk about:
Today in the show, we talk about:
- Types of business analytics
- Is cardinality estimation the most common cause for performance problems?
- How to answer the question “what do you do”?
- Old news about AWS max database size in RDS
- New project architecture challenges
- Reporting and comic books
- Scary bug with mirroring and database snapshot
In this show, we talk about everything that’s new in SQL Server 2017
Guy is currently having fun in Thailand, so we don’t have a new show this week. Instead, we republish one of our earlier episodes, where we talk about our favorite language – T-SQL. We’ll be back with a new show in two weeks.
Did you know that SQL was initially called “Sequel” (Structured English Query Language)?
On this show, we go back to basics and talk about our favorite language – Transact-SQL (T-SQL).
We cover a lot of topics in the fields of development, performance and maintenance. Among them:
- The logical phases of query processing
- Our favorite and least favorite T-SQL features
- T-SQL development best practices
- How to avoid writing long Stored Procedures
- How to avoid writing the “mother of all queries”
- The Axis of Evil T-SQL featrues
- Why you should (almost) never use table variables
Items mentioned in the show:
There are many ways for writing efficient queries in SQL Server. In this show we talk about a few of those ways, when the key is – “keep it simple”. In addition, we talk about use cases for Big Data, Ways for transferring data to a reporting server, an interesting BI project Guy is working on, and more