Basics of Dimensional Modeling
Introduction of how to design a star schema dimensional model for new BI developers
Estimates
Software estimates are often wildly off from the actual amount of time and resources that are required. Today Steve Jones looks at a few reasons why.
SQL Server Live! Orlando, FL
SQL Server Live! is designed to finely tune the skills of DBAs, developers, Business Intelligence specialists (just to mention a few) with five days of workshops, deep dives and breakout sessions from November 17 - 21 2014.
Importance of Recovery Model in SQL Server
Have you ever wondered why the transaction log file grows bigger and bigger? What caused it to happen? How do you control it? How does the recovery model of a database control the growing size of the transaction log? Read on to learn the answers.
A Call for Questions
Our Question of the day is very popular, but we're looking for more complex questions
Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
Misconfiguration is a Problem
The configuration of server systems matters. Not just to ensure software runs smoothly, but also for security.
Silicon Valley Code Camp
Code Camp is a community event where developers learn from fellow developers. This year's event will take place on October 11-12 in the Los Altos Hills in California. Speakers include Steve Jones, Nik Molnar, Anthony van der Hoorn, Mike Wood, and more. Register while space is available.
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers