An attendee at my PASS Summit precon on virtualized SQL Server performance tuning on Monday asked a great question. “Do you have a list of the tools and scripts...
2020-11-12 (first published: 2020-11-11)
289 reads
I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent...
2020-11-11
14 reads
I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent...
2020-11-16 (first published: 2020-11-11)
906 reads
Mike Walsh invited us on March 1st 2010 to write about I/O. This abbreviation stands for Input / Output, and is often used as shorthand for persisted storage. Given...
2020-11-11
23 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-11
26 reads
Tuesday notes! Today I’m in Execution Plans in Depth by Hugo Kornelis. Notes: Today the presenter is using the Cadmium/EventScribe platform instead of GotoWebinar Started off with a lot...
2020-11-11
26 reads
The election for the next PASS Board of Directors starts today, with a slate of 7 for three spots. I asked them for their vision last week, I’ve read...
2020-11-12 (first published: 2020-11-11)
121 reads
This week is a double-whammy of activity - T-SQL Tuesday and PASS Summit 2020. T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month,...
2020-11-11
16 reads
Is your SQL environment prepared for a disaster? There are big and small disasters and depending on your perspective big and small can mean different things. Preparing your environment...
2020-11-16 (first published: 2020-11-10)
652 reads
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Taiob Ali (b | t) and it’s about a topic I could...
2020-11-10
8 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers