Automated unit tests are part of many development shops’ basic workflow and have long been considered a best practice.
However they are not well suited for applications that are heavily dependant on sql, and it can be very difficult to …
Read MoreIt's not what you look at that matters, it's what you see.
Automated unit tests are part of many development shops’ basic workflow and have long been considered a best practice.
However they are not well suited for applications that are heavily dependant on sql, and it can be very difficult to …
Read MoreI have some coworkers that haven’t worked a lot with sql subqueries. Subqueries are a great tool, but can be confusing for folks who have limited sql experience. It’s my opinion that, like any code, good naming, proper formatting and …
Read MoreAt work we use JIRA to manage our sprints. I like JIRA, it’s got a nice interface, is easy to use, and has a variety of useful reports.
However, there are certain metrics that management uses to track our team …
Read MoreI really like Altova’s XMLSpy utility for browsing XML, creating XSDs and testing XPath queries. However Altova’s licensing model has made it difficult for me to use the tool.
The Altova licensing model is based on purchase plus annual support. …
Read MoreLast fall, I took and passed the microsoft 70-761 and 70-762 exams to achieve MCSA (Microsoft Certified Solutions Associate) status for sql server 2016.
I’m planning to take the next step this spring, to MCSE. Achieving MCSE certification consists of …
Read MoreI’ve been looking into table partitioning as a way to manage large historical tables. The idea is to be able to keep the size of the table reasonably static as new rows are inserted by removing older rows. My goal …
Read MoreRecently I had a need to assign a user DBO to all databases on a server.
I put this script together, it seems to do the trick.
declare @login varchar(255)='testuser' declare @databasename varchar(255), @sql varchar(max) declare xcn cursor fast_forward local… Read More
SQL Server supports SQL Mail for email notifications, and traditionally I’ve used SQL Mail to keep myself apprised of various server issues.
Slack is a great alternative to email, and a lot of folks make extensive use of slack. I …
Read MoreTo create a CLR stored procedure in SQL Server….
I used this nice blog posting by Scott Sutherland as a starting point:
https://blog.netspi.com/attacking-sql-server-clr-assemblies/
If you are using SQL Server 2017 it will be necessary to sign your CLR assembly.
If …
Read MoreOne of the things that I really like about Microsoft products (and one of the reasons for their success) is the very well documented and very capable APIs that Microsoft provides. Dynamics is no exception.
Here are some helpful links …
Read More