Database Fundamentals #14: Modifying Data Through SSMS
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
497 reads
The Scary DBA
Database Fundamentals #13: Data Entry Through T-SQL
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...
2017-10-23 (first published: 2017-10-11)
1,863 reads
Database Fundamentals #12: Adding Data with SSMS GUI
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...
2017-09-25
434 reads
Azure, PowerShell, Databases and the PASS Summit
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
427 reads
Database Fundamentals #11: Why Learn T-SQL
If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and...
2017-09-21 (first published: 2017-09-18)
1,963 reads
Speaking at IT/DevConnections 2017
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
339 reads
Database Fundamentals #10: Modifying Tables
Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change...
2017-09-12
390 reads
Database Fundamentals #9: Schemas As Containers
Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...
2017-09-14 (first published: 2017-09-06)
2,299 reads
Luck and the PASS Summit
I recently read an article asking the question whether or not we downplay the role that luck plays in our...
2017-09-05
319 reads
Ich werde Deutschland beriesen
Guten Tag!
OK, switching back to English for the rest of this.
I’m going to be spending a few weeks in Germany...
2017-08-30
528 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers