Large Chunks of Data
This Friday Steve Jones talks reporting. Specifically he wonders how long can a report be before it's just wasting space.
2015-04-03 (first published: 2010-09-17)
356 reads
Editorials
2015-04-01
309 reads
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
148 reads
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
2015-03-30
97 reads
Efficiency
This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you getting more efficient?
2015-03-26 (first published: 2010-10-22)
309 reads
Are There That Many GUIDs?
Steve Jones talks about a recent survey that showed more people use GUIDs as primary keys than identity values.
2015-03-24 (first published: 2010-10-12)
665 reads
First Episodes
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
2015-03-23
116 reads
Microservices, SOA and Service Broker
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
2015-03-23
450 reads
Microsoft and R
R is an interesting language and one that might become more important to data professionals in the future. Microsoft is also making an investment here.
2015-03-19
490 reads
2015-03-18
786 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers