Iterating Over SQL Server Certificates with Cursors Welcome to another SQL Server educational post! Today, we’re going to explore how to use cursors to iterate over all certificates in the sys.certificates system view. Cursors can be handy when you need to process each row in a result set individually. A T-SQL (Transact-SQL) cursor is a database object used in SQL …
Iterating Over SQL Server Certificates with Cursors Read more »
A cursor is a tool in SQL Server that allows a user to traverse through the rows of a result set one row at a time. This can be useful for performing operations on each row of the result set individually, such as updating or deleting specific rows. Cursors are created using the DECLARE CURSOR statement, and are associated with …
Here is the outline: Using Cursors Using String Functions Here is the link to the Google On Air Broadcast where you can watch for free. https://plus.google.com/events/ci8jms67qttuteegimrf4sj70sk After the presentation, I will update this page with a link to the YouTube video. This session will be about 90 minutes, Aaron Buma will present about half and I will present the other …
Today’s Live Training: Using Cursors and TSQL String Functions Read more »
On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare developers for the Microsoft 70-461 SQL Queries exam. This week we will be a two part session Using Cursors, followed by Using String Functions. This is provided free of charge to give back to the SQL community. Here is …
Using Cursors, followed by Using String Functions Read more »
Next week as part of the free SQL Query training that Aaron Buma and I provide, the topic I will be presenting is cursors. How to use them, what they are, everything you ever wanted to know. My concern in this presentation is that cursors have caused me many headaches in regard to performance over time. The main problem that …
Learn how a worktable table applies in the realm of SQL Server, efficient query processing and resource management are crucial for maintaining performance and reliability. One of the often-overlooked components that play a vital role in query execution is the worktable. In this blog post, we’ll delve into what worktables are, how they function, and why they are important for …
Introduction: In my years of working with SQL Server, I’ve encountered a variety of common mistakes that can impact performance and database health. In this blog post, I’ll share these pitfalls and provide tips on how to avoid them. Remember, understanding these mistakes is the first step in enhancing your SQL Server’s Performance. Ignoring Database NormalizationNormalization is crucial for reducing …
Common SQL Server Mistakes and How To Avoid Them Read more »
Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or Aurora PostgreSQL can be challenging due to incompatibilities in data types, and in functions. What is promised in Babelfish is that it will create a layer between standard SQL Server TSQL and PostgreSQL to be …
Occasionally I have come across the need to save the output from a query to a varchar value, for instance varchar(max). There are lots of ways to do this, could you use a cursor and just append to a string each loop through the cursor, but there is an easier way. Examples of a need to do this would be …
In this presentation we will be training on TSQL Functions, there will be three sections. Date and Time Functions Logical Functions User Defined Functions Here is the link to the Google On Air Broadcast where you can watch live (or recorded later) for free. https://plus.google.com/events/cb0pj9ghp5elt6i241kstphcvr0 Here are the slides. And here is the broadcast at YouTube: This session will be …