MDX Puzzle #7
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
470 reads
Blog Posts
Restarting SQL Server using a Batch Script
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
12,184 reads
Restarting SQL Server using the GUI
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
480 reads
Jax Code Camp - My Presentation and Projects
First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...
2010-08-28
415 reads
Microsoft Offers New Certification Exam Discount
If you are intending to take any Microsoft Certification tests soon, you are in luck, because Microsoft has recently introduced...
2010-08-28
1,263 reads
Connectify
It’s a wired world. You’d think by this point, most major hotels, at least those costing upwards of $100/night, would...
2010-08-27
1,038 reads
Free SQL Server Training for the Week of August 30, 2010
The only scheduled event among the sources I have listed is the one for SQL Lunch, so it looks to...
2010-08-27
593 reads
Furniture Grade PVC – What Will You Make?
Ran across this in my weekly browsing, Formufit sells furniture grade PVC. I think I’m not quite clear on the...
2010-08-27
1,160 reads
Kent SqlServer UserGroup
I am now in the process of arranging the 2nd meeting of the kent sqlserver user group. This will be...
2010-08-27
421 reads
MDX Puzzle #6 - Solution
Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER...
2010-08-27
481 reads
Blogs
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Forums
Pivot query
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Table with FK(s) to other columns within the table
Hello All, I have recently joined a project, where main, core tables with millions...
SQL 2017 throwing BugCheck on differential database restore
Long time listener, first time caller. I have a problem that my usual bag...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers