2019-06-26
84 reads
Editorials
Spread the Word about Basic Security
This week we have a few back to the basics security comments from Steve.
2019-06-25
127 reads
Killing FTS
Steve wonders today if the Full-Text Search system in SQL Server is due for a replacement, perhaps with other technologies.
2019-06-24
182 reads
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
134 reads
Practice Those Scripts
A database script caused a large outage for Salesforce. Steve wonders if you have ideas on how to prevent this type of issue in your environment.
2019-06-21
272 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
149 reads
An Alert Philosophy
Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
2019-06-19
193 reads
Segments for Protection
Computer network security is important, and it's something we ought to be more concerned with as data professionals.
2019-06-18
139 reads
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
2019-06-17 (first published: 2015-03-27)
967 reads
Microsoft and Oracle Cloud Partnership
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
170 reads
Blogs
SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
Next month, Microsoft is ending five years of extended support on SQL Server 2008...
Understanding Columnstore Indexes in SQL Server Part 1
Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes...
Basic User Functions in R
By Steve Jones
As I’ve been learning more about the data platform, I’ve been exposed to some...
Forums
Compare Dates
Hello All, create table #app1 ( custID INT, Seqs INT, eff_dt datetime, term_dt datetime...
StoredProc insert and update multiuser issue
Happy to day to all, I am looking into an issue with a stored...
New to SQL - difficulties in SUMing only certain rows of a column, other misc.
This is for SQL Server 8.0 and I'm using MySQL Workbench on this. ...
Ask SSC