Blog: Bill Fellows

209 blogs updated: 72 min. ago
What's my transaction isolation level
What's my transaction isolation levelThat's an easy question to answer - StackOverflow has a fine answer. But, what if I use sp_executesql t...
10-11-2017 00:03:13 Bill Fellows SQL Server
Temporal table maker
Temporal table makerThis post is another in the continuing theme of "making things consistent." We were voluntold to help another team get t...
12-10-2017 15:54:42 Bill Fellows SQL Server
Broken View Finder
Broken View FinderShh, shhhhhh, we're being very very quiet, we're hunting broken views. Recently, we were asked to migrate some code change...
05-10-2017 15:42:41 Bill Fellows SQL Server
Biml Query Table Builder
Biml Query Table BuilderWe previously noted the awesomeness that is SQL Server 2012+'s ability to expose a query's metadata. Let's look how ...
05-09-2017 15:00:24 Bill Fellows SQL Server
SQL Server Query Metadata
SQL Server Query MetadataPop quiz, how you determine the metadata of a query in SQL Server? For a table, you can query the sys.schemas/sys.t...
30-08-2017 07:52:12 Bill Fellows SQL Server
Python pyinstaller erroring with takes 4 positional arguments but 5 were given
Pyinstaller is a program for turning python files into executable programs. This is helpful as it removes the requirement for having the pyt...
28-08-2017 17:40:08 Bill Fellows SQL Server
Biml build Database collection nodes
Biml build Database collection nodes aka what good are AnnotationsIn many of the walkthroughs on creating relational objects via Biml, it se...
15-08-2017 16:06:53 Bill Fellows SQL Server
Generate TSQL time slices
I had some log data I wanted to bucket into 15 second time slices and I figured if I have solved this once, I will need to do it again so to...
28-07-2017 19:37:01 Bill Fellows SQL Server
Rename default constraints
This week I'm dealing with synchronizing tables between environments and it seems that regardless of what tool I'm using for schema compare,...
30-06-2017 18:46:27 Bill Fellows SQL Server
Variable scoping in TSQL isn't a thing
It's a pop quiz kind of day: run the code through your mental parser. BEGIN TRY DECLARE @foo varchar(30) = 'Created in try block'; DECLARE @...
22-03-2017 21:23:37 Bill Fellows SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.