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.
How to get Database Design Horribly Wrong
Database Design is one of those tasks where you have to carefully get all the major aspects right. If you mess-up just one of these, it can all go horribly wrong. So what are these aspects that can ruin database design, and how can you get them right? Robert Sheldon explains.
SQL Saturday #364 - Boston, MA
SQL Saturday is coming to Boston on April 18th 2015. Join us for a free day of SQL Server training and networking, and listen to great speakers like Grant Fritchey, Brent Ozar, and Andy Leonard. Register while space is available.
Using the ROLLUP, CUBE, and GROUPING SETS Operators
Greg Larsen discusses the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals. Read on to find out more about these additional GROUP BY operators.
What is Behaviour Driven (Database) Development?
Behaviour Driven Development (BDD) is not always clearly understood, and the term is particularly unfamiliar in database circles. Seb Rose introduces us to the fundamentals of BDD, and make some suggestions for how it might be relevant to database development.
Computational Biologist
A job Steve Jones has never heard of is using data to improve medical treatments.
Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
Calculate the Statistical Mode in SQL Server using T-SQL
Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Server, but how can we determine the mode using T-SQL?
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Niaga Grisenda TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Komplek, Ruko Niaga Grisenda, Jl. Pantai Indah Kapuk Jl. Kapuk Raya No.19-20 Blok GE,...
BCA KCP Iskandar Muda TLP/WA 08216977701
Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec. Kebayoran Lama, Kota...
BCA KCP Percetakan Negara HUB/WA 08216977701
Jl. Percetakan Negara No.223 C, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers