Deschide articolul original într-un tab nou Schimbarea acestei opțiuni se aplică imediat și reîncarcă pagina.
LECTURA
Înapoi la articole →

Data with Bert

bertwagner.com/atom.xml
Vizitează site-ul

Cel mai recent articol

Ultima verificare

Urmăritori 0 urmăritori
Articole: 100

  1. Dipping into the Cookie Jar

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill.

  2. Time Zones and Daylight Saving Time

    (Data with Bert)

    Watch this week's video on YouTube AT TIME ZONE is great because it makes it easy to perform daylight saving time and time zone conversions in our queries.

  3. Searching Complex JSON Data

    (Data with Bert)

    Watch this week's video on YouTube Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.

  4. COUNT, DISTINCT, and NULLs

    (Data with Bert)

    Watch this week's video on YouTube One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the number of unique values in a column.

  5. Parsing HTML in SQL Server

    (Data with Bert)

    Watch this week's video on YouTube Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.

  6. Why make?

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard.

  7. Automating Database Maintenance with Jess Pomfret and dbatools

    (Data with Bert)

    Watch this week's video on YouTube dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your SQL Server instances a breeze.

  8. Cardinality: Not Just For The Birds

    (Data with Bert)

    Watch this week's video on YouTube When building indexes for your queries, the order of your index key columns matters.

  9. Optimizing for Ad Hoc Workloads

    (Data with Bert)

    Watch this week's video on YouTube The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that plan in the plan cache to be reused again at a later date.

  10. SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

    (Data with Bert)

    Watch this week's video on YouTube While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.

  11. T-SQL Documentation Generator

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley.

  12. Visualizing Hash Match Join Internals And Understanding Their Implications

    (Data with Bert)

    This post is part 3 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 2 - merge joins).

  13. 2018 Community Influencer of the Year

    (Data with Bert)

    A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.

  14. Visualizing Merge Join Internals And Understanding Their Implications

    (Data with Bert)

    This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match joins).

  15. Visualizing Nested Loops Joins And Understanding Their Implications

    (Data with Bert)

    This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).

  16. Two Words For Faster Scalar Functions

    (Data with Bert)

    Watch this week's video on YouTube WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005.

  17. Brute Forcing SQL Logins and Passwords

    (Data with Bert)

    Watch this week's video on YouTube Following up on last week's post about the different types of SQL injection, this week I want to show how injection can be used to obtain a SQL login and its password.

  18. 4 SQL Injection Techniques For Stealing Data

    (Data with Bert)

    Watch this week's video on YouTube I'm not advocating that you start using SQL injection to start stealing other people's data.

  19. Bert & Pinal Troubleshoot a Slow Performing SQL Server

    (Data with Bert)

    Watch this week's video on YouTube What happens when you run into performance tuning expert Pinal Dave?

  20. Learning New Skills

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #108 prompt by Malathi Mahadevan.

  21. The 5 Scariest Moments for a SQL Server Developer

    (Data with Bert)

    Watch this week's video on YouTube While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it'd be way scarier to talk about truncate tables and source control.

  22. Unexpected Shorthand Date Implicit Conversions

    (Data with Bert)

    I do my best work in the mornings.

  23. Conditionally Returning Rows Based On Query Results

    (Data with Bert)

    Watch this week's video on YouTube While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to my SQL queries.

  24. The Project Graveyard

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #107 prompt by Jeff Mlakar.

  25. Power BI Dashboards, Reports, and Datasets with the SQL Chefs

    (Data with Bert)

    Watch this week's video on YouTube This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh, delicious, chocolate chip cookies.

  26. Shortchanged with International Money in SQL Server

    (Data with Bert)

    Watch this week's video on YouTube Imagine you have to perform some salary analysis for your employer International Mega Corp.

  27. Extracting JSON Values Longer Than 4000 Characters

    (Data with Bert)

    Watch this week's video on YouTube A while back I built an automated process that parses JSON strings into a relational format.

  28. Faking Temporal Tables with Triggers

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #106 prompt by Steve Jones.

  29. Does The Order Of Index Columns Matter?

    (Data with Bert)

    Watch this week's video on YouTube When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.

  30. Ignoring NULLs with FIRST_VALUE

    (Data with Bert)

    Watch this week's video on YouTube The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."

  31. FizzBuzz and Multiple Recursive Member CTEs

    (Data with Bert)

    Watch this week's video on YouTube Last week I needed to write a recursive common table expression.

  32. 6 Techniques For Troubleshooting Your Code

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #105 prompt by Wayne Sheffield.

  33. Displaying Long Values in SSMS

    (Data with Bert)

    Watch this week's video on YouTube I write a lot of dynamic SQL and frequently encounter variables that contain many characters: DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) + N'SELECT ''A'' AS AShortValue, '''+REPLICATE(N'A',4000…

  34. Should You Use Index Hints?

    (Data with Bert)

    Watch this week's video on YouTube One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.

  35. Pinal Dave Helps Me Fix My Performance Tuning Problems

    (Data with Bert)

    Watch this week's video on YouTube This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself.

  36. T-SQL Tuesday #104 Roundup

    (Data with Bert)

    This month's T-SQL Tuesday topic asked "What code would you hate to live without?"

  37. Building Dynamic Table-Driven Queries

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #104 prompt by me!

  38. Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

    (Data with Bert)

    The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.

  39. Filtering Tables, Procedures, And Other Objects In SSMS

    (Data with Bert)

    Watch this week's video on YouTube While the text of this post contains good information on SSMS object filters, I highly recommend watching this week's video on YouTube - I stretched my creativity with filming this week while I was on vacation.

  40. Join Elimination: When SQL Server Removes Unnecessary Tables

    (Data with Bert)

    In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server.

  41. Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

    (Data with Bert)

    Watch this week's video on YouTube I love continuing my education in SQL Server.

  42. 4 Ways To Define Lookup Values In A Query

    (Data with Bert)

    Watch this week's video on YouTube Occasionally you may need to create a lookup table of values for a single query.

  43. What Does The GO Command Do?

    (Data with Bert)

    Watch this week's video on YouTube When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons.

  44. Converting JSON to SQL Server CREATE TABLE Statements

    (Data with Bert)

    Watch this week's video on YouTube Tedious, repetitive tasks are the bane of any lazy programmer.

  45. Why Is My VARCHAR(MAX) Variable Getting Truncated?

    (Data with Bert)

    Watch this week's video on YouTube Watch this week's episode on YouTube.

  46. Contributing to Community

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #102 prompt by Riley Major.

  47. Is It Possible To Conditionally Index JSON Data?

    (Data with Bert)

    Watch this week's video on YouTube Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!)

  48. The Forgotten Fourth SQL Server Recovery Model

    (Data with Bert)

    Watch this week's video on YouTube SQL Server recovery models define when database transactions are written to the transaction log.

  49. In-Memory OLTP: A Case Study

    (Data with Bert)

    Watch this week's video on YouTube When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it.

  50. 3 Essential Tools For The SQL Server Developer

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #101 prompt by Jens Vestergaard.