Notes from SQLSaturday Jacksonville 2023
Year 15 for Jacksonville! SQLSaturday Jax was held on May 6 this year, back at the usual location on the campus of the University of North Florida. At the...
2023-06-23 (first published: 2023-06-13)
189 reads
Blog Posts
Agile West–How Do I Get Started with Database DevOps
This week I had the chance to deliver a talk at Agile West in Las Vegas. I linked some resources on my blog, and feel free to check them...
2023-06-21
63 reads
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it doesn’t require installation of an Oracle client. But because of this, you may not have...
2023-06-21 (first published: 2023-06-03)
399 reads
What are Statistics in SQL Server?
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2023-06-21
327 reads
What is Always Encrypted and how does it work?
Always Encrypted was a new encryption feature added to SQL Server with the 2016 version of the product. Initially it was just available in enterprise edition, but from SQL...
2023-06-21 (first published: 2023-06-05)
372 reads
Indexes and Statistics with Always Encrypted
In this short post we look at the ability to be able to have (or not) indexes on columns encrypted using Always Encrypted.
2023-06-20
153 reads
List Top Tables in SQL Server Database by Size
There are countless queries you can find on internet to get list of tables, size of database, tables, indexes etc... Here is a one that I have used for...
2023-06-20
437 reads
T-SQL Tuesday 163: Best piece of career advice
This month’s T-SQL Tuesday is hosted by Gethyn Ellis(t). Gethyn’s Invite to us is to write about the best piece of career advice you’ve received. One of the most...
2023-06-20
47 reads
What Do You Look for in an Execution Plan?
Say, you have a query having performance issues and you decide to look it's graphical execution plan in SSMS (or other tools). If you are lucky, right off the...
2023-06-20 (first published: 2023-06-19)
195 reads
Flyway with Multiple Folders
A customer asked about how they could organize their migration scripts in different ways to manage them and worried about it being complex. I decided to test a few...
2023-06-19 (first published: 2023-05-31)
163 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCU Rawamangun Telp:0821-815-4374
Telp/WA +62 821-815-4374 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat BCA KCP Permata Ujung Menteng Tlp:0817-825-533
Telp/WA +62 817-825-533 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil,...
Alamat BCA KCP Matraman Telp:0821-755-5651
Telp/WA +62 821-755-5651 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers