PowerShell- Monitoring Multiple Services On Multiple Servers Using WMI Class -Win32_Service
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
631 reads
Change Availability Group Endpoint IP
I had someone email me and ask how they could change the IP address on their Availability Group Endpoint. It’s...
2016-01-26 (first published: 2016-01-14)
1,543 reads
What is RESULT SETS?
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...
2016-01-26 (first published: 2016-01-14)
8,329 reads
10 Years of Blogging
Yesterday, on the 13th of January 2016, my blog has reached it’s 10th anniversary. It all started precisely 10 years...
2016-01-14
454 reads
Rebuilding a Heap–Don’t Do It
I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but...
2016-01-14
1,785 reads
Goodness-of-Fit Testing with SQL Server Part 4.1: R2, RMSE and Regression-Related Routines
By Steve Bolton
…………Throughout most of this series of amateur self-tutorials, the main topic has been and will continue to be...
2016-01-25 (first published: 2016-01-13)
1,979 reads
SQL Server Statistics - Histograms
Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics...
2016-01-25 (first published: 2016-01-13)
3,241 reads
T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage
What is code coverage?
When you write some code and then test it, how sure are you that you have...
2016-01-22 (first published: 2016-01-13)
2,079 reads
T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that you have tested the whole thing? Code coverage gives...
2016-01-13
16 reads
T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that...
2016-01-13
75 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers