Blog: Bill Fellows


213 blogs updated: 46 min. ago
SQL Server Agent Job Sort Order
SQL Server Agent Job Sort OrderToday's post could also be titled "I have no idea what is happening here." We have an agent job, "Job - Do St...
3
26-10-2018 16:16:20 Bill Fellows SQL Server
Polling in SQL Agent
Polling in SQL Agent A fun question over on StackOverflow asked about using SQL Agent with SSIS to poll for a file's existence. As the comme...
0
18-10-2018 15:11:34 Bill Fellows SQL Server
Biml Excel Data Source without Excel
Biml Excel Meta Data Source without ExcelIn the previous post, Reading Excel files without Excel, I showed some simple code to consume Excel...
0
09-10-2018 16:00:02 Bill Fellows SQL Server
Reading Excel files without Excel
Reading Excel files without ExcelA common problem working with Excel data is Excel itself. Working with it programatically requires an insta...
0
08-10-2018 16:11:24 Bill Fellows SQL Server
A data dimension for SQL Server
A data dimension for SQL ServerThe most common table you will find in a data warehouse will be the date dimension. There is no "right" imple...
0
14-08-2018 16:06:56 Bill Fellows SQL Server
Sort SQL Server tables into similarly sized buckets
Sort SQL Server Tables into similarly sized bucketsYou need to do something to all of the tables in SQL Server. That something can be anythi...
0
29-05-2018 16:48:02 Bill Fellows SQL Server
Sort SQL Server tables into similarly sized buckets
Sort SQL Server Tables into similarly sized bucketsYou need to do something to all of the tables in SQL Server. That something can be anythi...
0
05-04-2018 15:14:42 Bill Fellows SQL Server
2018 MVP Summit retrospective
2018 MVP Summit retrospective Another year of the MVP Summit is in the bag and as always, I have months worth of learning I'm excited to do....
0
12-03-2018 14:54:49 Bill Fellows SQL Server
Python pandas repeating character tester
Python pandas repeating character testerAt one of our clients, we are data profiling. They have a mainframe, it's been running for so long, ...
0
02-03-2018 15:38:49 Bill Fellows SQL Server
Pop Quiz - REPLACE in SQL Server
It's amazing the things I've run into with SQL Server this week that I never noticed. In today's pop quiz, let's look at REPLACE DECLARE @Re...
0
23-02-2018 15:13:13 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.