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
99 reads
Editorials
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)
824 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
141 reads
2019-06-14 (first published: 2015-05-19)
529 reads
Upgrading Your OS
Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.
2019-06-13
141 reads
NOSQL and RDBMSs
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2019-06-12 (first published: 2015-08-27)
584 reads
Are We Suckers?
This week Steve Jones wonders if we work too much. Do we give more to our employers than they give to us?
2019-06-11 (first published: 2015-12-18)
553 reads
Setting Session Skill Levels
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
2019-06-10
163 reads
Building or Buying Analytics
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
2019-06-08
139 reads
Microsoft Exercise
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
2019-06-07 (first published: 2015-04-27)
522 reads
Blogs
Scalar Valued Functions in SQL Server 2019
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Globally Distributed Azure Cosmos DB
By Arun Sirpal
Let’s use the Azure portal to build a globally distributed Cosmos DB. Before doing...
Trailing Spaces in SQL Server
By Bert Wagner
Watch this week’s episode on YouTube. A long time ago I built an application...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
create a query dragging the previous value
Hi Does someone know how to implement a query that performs multiples dynamic operations...
Query help
I have to insert data into archive table called Archive_table from Table A based...
Ask SSC