Import export wizard at the commandline
TweetG’day,
Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something...
2014-05-12
1,837 reads
Psst! Wanna some API?
If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool...
2014-05-11
708 reads
Data Collection in SQL Server
Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+...
2014-05-11
878 reads
Thanks to Toadworld.com team for recognition !
Thanks to Toadworld.com team for recognition !
Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit...
2014-05-11
703 reads
That “Cannot Generate SSPI Context” headache
Problem : You have completed an SQL Server setup on a new instance. The setup is successful, you can connect locally...
2014-05-10
1,532 reads
Allowing your App team to run SQL Agent Jobs
Problem : In most of your projects, there is always that situation that the application team have that need to run...
2014-05-10
681 reads
SSRS #74 – 2008 Cascading bug when you have a middle parameter
Some SSRS reports have a large number of parameters
I recently had a chance to help a co-worker to modify...
2014-05-09
1,778 reads
Quick Snapshot
The idea for this script came at times when I was having a project that needed to use snapshots of databases...
2014-05-09
108 reads
Script for database snapshot
The idea for this script came at a time when I was having a project that needed to use snapshots...
2014-05-09
124 reads
Reblog: May 2 to May 8
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-05-09
945 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
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