Blog: Bill Fellows

209 blogs updated: 43 min. ago
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
Getting Windows share via python
Windows network shares with pythonBackstoryOn a daily basis, we receive data extracts from a mainframe. They provide a header and data file ...
08-03-2017 15:36:57 Bill Fellows SQL Server
Biml Database Inspection
Biml Database Inspection Importing tables via BimlI've mentioned how using Biml to reverse engineer a very large database was the only optio...
23-02-2017 16:11:12 Bill Fellows SQL Server
Playing audio via Biml
Playing audio via BimlHow often do you need to play audio while you're compiling your Biml packages? Never? Really? Huh, just me then. Very ...
09-11-2016 18:51:59 Bill Fellows SQL Server
What packages still use Configuration?
What packages still use Configurations?I'm sitting in Tim Mitchell's excellent "Deep Dive into the SSISDB session" and someone asked how the...
28-10-2016 20:04:06 Bill Fellows SQL Server
Debugging Biml
Debugging BimlAt this point, I don't even know who to give credit for on this tip/trick as I've seen it from so many luminaries in the field...
18-10-2016 19:07:32 Bill Fellows SQL Server
UNION removes duplicates
UNION removes duplicatesWhen you need to combine two sets of data together, we use the UNION operator. That comes in two flavors: UNION and ...
06-10-2016 19:38:42 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.