Check List for SQL Server Connectivity Issue !
SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.
Error :
A...
2012-09-28
1,519 reads
I voted in the PASS Election - you should too!
If you are a member of PASS you have probably already received an email that looks like this:
--
From: <hq@sqlpass.org>
Date: Fri,...
2012-09-28
1,691 reads
Use Powershell to Manage Idera SQL Diagnostic Manager
Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...
2012-09-28
2,770 reads
Time to Vote-PASS Board of Directors
It’s that time of year where we get to vote for the three best candidates to serve a two year...
2012-09-28
1,519 reads
SQL Saturday 151 Interview: Stacia Misner
Hello Dear Reader SQL Saturday 151 is just around the corner. If you haven't registerd there is still time to...
2012-09-27
1,730 reads
Full Text Search – CONTAINS
I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators....
2012-09-27
4,835 reads
Cannot assign a default value to a local variable !
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...
2012-09-27
2,953 reads
SQL SERVER : How to List All Email Subscription configured in SSRS ?
Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...
2012-09-27
14,824 reads
MDS Error: “The status of the specified batch is not valid”
In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch...
2012-09-27
2,376 reads
Off to the Center of the Universe
“New York City…center of the universe..” – Rent
I’m off to New York this morning for the start of the 2012 SQL...
2012-09-27
1,704 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