Looking Forward
2018 has come and gone. And we’re on a new year once again. This is another opportunity for a new...
2019-01-04
240 reads
2018 has come and gone. And we’re on a new year once again. This is another opportunity for a new...
2019-01-04
240 reads
More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...
2019-01-03 (first published: 2018-12-22)
2,440 reads
It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a...
2018-11-02
289 reads
SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...
2018-04-11
937 reads
Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct...
2018-04-05 (first published: 2018-04-03)
2,533 reads
As a SQL Server pro, I spend most of my productive time in the SQL Server Management Studio (SSMS). I...
2018-04-04 (first published: 2018-03-27)
2,950 reads
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...
2018-03-22 (first published: 2018-03-13)
4,304 reads
Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited...
2018-03-20
440 reads
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,694 reads
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
5,873 reads
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
This may or may not be helpful in the long term, but since I’m...
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Comments posted to this topic are about the item Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers