Profile cover photo
Profile photo
Bill Fellows
439 followers -
Awesome, awesome-coated awesomeness with awesome-filling
Awesome, awesome-coated awesomeness with awesome-filling

439 followers
About
Posts

Post has attachment
Sort SQL Server tables into similarly sized buckets
Sort SQL Server Tables into similarly sized buckets You need to do something to all of the tables in SQL Server. That something can be anything: reindex/reorg, export the data, perform some other maintenance---it really doesn't matter. What does matter is t...
Add a comment...

Post has attachment
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. Thank you I'd like to extend a hearty thank you to Microsoft and the various teams for hosting us. I can't imagine t...
2018 MVP Summit retrospective
2018 MVP Summit retrospective
billfellows.blogspot.com
Add a comment...

Post has attachment
Python pandas repeating character tester
Python pandas repeating character tester At one of our clients, we are data profiling. They have a mainframe, it's been running for so long, they no longer have SMEs for their data. We've been able to leverage Service Broker to provide a real-time, under 3 ...
Add a comment...

Post has attachment
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
@Repro table
(
SourceColumn varchar(30)
);

INSERT INTO
@Repro
(
SourceColumn
)
SELECT
D.SourceColu...
Add a comment...

Post has attachment
Altering table types, part 2
Altering table types - a compatibility guide In yesterday's post , I altered a table type. Pray I don't alter them further. What else is incompatible with an integer column? It's just a morbid curiosity at this point as I don't recall having ever seen this ...
Add a comment...

Post has attachment
Pop quiz - altering column types
Pop quiz Given the following DDL CREATE TABLE dbo.IntToTime
(
CREATE_TIME int
); What will be the result of issuing the following command? ALTER TABLE dbo.IntToTime ALTER COLUMN CREATE_TIME time NULL; Clearly, if I'm asking, it's not what you might expe...
Add a comment...

Post has attachment
**
What are all the functions and their parameters? File this one under: I wrote it once, may I never need it again In my ever expanding quest for getting all the metadata, I how could I determine the metadata for all my table valued functions? No problem, tha...
Add a comment...

Post has attachment
Staging Metadata Framework for the Unknown
Staging metadata framework for the unknown That's a terrible title but it's the best I got. A client would like to report out of ServiceNow some metrics not readily available in the PowerBI App. The first time I connected, I got a quick look at the Incident...
Add a comment...

Post has attachment
Python Azure Function requestor's IP address
Python Azure Function requestor's IP address I'm working on an anonymous level Azure Function in python and couldn't find where they stored the IP address of the caller, if applicable. It's in the request headers , which makes sense but not until I spent fa...
Add a comment...

Post has attachment
What's my transaction isolation level
What's my transaction isolation level That's an easy question to answer - StackOverflow has a fine answer. But, what if I use sp_executesql to run some dynamic sql - does it default the connection isolation level? If I change isolation level within the quer...
Add a comment...
Wait while more posts are being loaded