Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...
2014-08-11 (first published: 2014-08-04)
8,816 reads
Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as...
2014-07-22
487 reads
Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...
2014-07-07
654 reads
Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize...
2014-06-30
1,893 reads
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
743 reads
When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...
2014-06-17 (first published: 2014-06-15)
3,601 reads
Imagine that you have a table of customers
createtable Customer
(
Name varchar(30),
LastName varchar(30),
Title varchar(30)
);
go
insertinto Customer values('Alex','Smith','Mr.');
insertinto Customer values('John','Doe','Dr.');
goNow you selecting list...
2014-06-10 (first published: 2014-06-09)
1,879 reads
It may happenthatyou have a needto check thescripts thatyou have on yourdisk. For example, it may be part of yourbuildprocess.So how...
2014-06-02
1,831 reads
Today we released new version of SQL Code Guard, 2.5.5257
Main changes:
SQL Code Guard is digitally signed now to satisfy corporate...
2014-05-26
775 reads
Today I've replaced download package for ExpressProfiler with digitally signed version of standalone application and Ecosystem installation.
Unfortunately I did something wrong and...
2014-05-24
592 reads
By DataOnWheels
SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has...
By Chris Yates
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks,...
By Rohit Garg
What Is TempDB and Why It Matters TempDB is a shared system database in SQL...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item When DBAs Should Consider Using...
Hi all, I have a data flow task with: Flat File Source (csv) ->...
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers