This gallery contains 5 photos.
It appears that on some Kindle devices, it is hard to read the tables. Therefore, on request, I’ve put the screenshots of the tables here. Tip: you can also read the eBook on Amazon Cloud Reader (https://read.amazon.com)
At times, you have to create reports in Word format. If these are reports you have to create on a regular basis, you’ll want to automate this as much as possible. There is a lot you can do to automate … Continue reading
This video demonstrates the installation for SQL Server 2008 R2. It is supporting material for my eBook on Database Fundamentals, which covers the Microsoft MTA 98-364 exam. In this video, I explain the installation process step by step. The purpose of … Continue reading
This could be my shortest post ever, with a simple “yes”, but let me elaborate. At times, you have to restart a service. With Powershell, this is easy enough (provided you have the right permissions): Restart-Service -name will do the … Continue reading
Finally, I’ve finished my book on the Microsoft Technology Associate 98-364 exam: Database Fundamentals. It’s available in the iTunes book store: https://itunes.apple.com/us/book/id1043228558 I decided to make it an iBook, since this format provides a combination of text, screenshots, screencasts and interactive test … Continue reading
On a normal server, there are several Powershell ways to get a list of all installed SQL instances. Probably the most straightforward way is to query the registry:
|
1 2 |
Get-Itemproperty -path 'HKLM:\software\microsoft\Microsoft SQL Server' ` | Select-Object -expandproperty installedinstances |
You can subsequently use the output to query all instances on … Continue reading
Every now and then, I have to tackle a performance problem on a SQL Server I’ve never seen before. One of the things I’ll be looking for is the block size of the disks. The block size for drives containing … Continue reading
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
SELECT 'Average' = AVG(quantity) ,'Average #2' = AVG(CAST(quantity as decimal(5,2))) ,'Number' = COUNT(*) ,'Maximum' = MAX(quantity) ,'Minimum' = MIN(quantity) ,'Total' = SUM(quantity) FROM Orderlines; SELECT OrderDate ,'Payment due' = DATEADD(m,1,OrderDate) ,'Days ago' = DATEDIFF(dd,OrderDate,GETDATE()) ,'Today' = GETDATE() FROM Orders; SELECT 'Left 3' = LEFT('ABCDE', 3) ,'Length' = LEN('ABCDE') ,'Lower case' = LOWER('Abcde') ,'No leading spaces' = (LTRIM(' ABCDE')) ,'Right 3' = RIGHT('ABCDE', 3) ,'No trailing spaces' = RTRIM('ABCDE ') ,'Upper case' = UPPER('Abcde'); --create function CREATE FUNCTION fnDoubler (@input INT) RETURNS INT AS BEGIN SET @input = @input * 2; RETURN @input END --call function SELECT '16 * 2 = ' = dbo.fndoubler(16); -- Create the Logging table CREATE TABLE [dbo].[Logging] ( LogTime smalldatetime , LogMessage varchar(1000)); |
Lately, I’ve been creating, deleting and recreating a lot of virtual machines with Oracle VirtualBox. So today, when I needed to start with a clean environment, I decided to create a virtual machine using the command line instead of the … Continue reading
Sometimes, the query optimizer makes mistakes. Instead of selecting the most optimal plan, a sub-optimal plan is chosen, and it is your task as a DBA to help SQL choose the right plan. In this case, the optimizer overestimated the … Continue reading
