PowerShell Remote Commands
This is something I've found useful here recently when I had a server acting up. It's a simple way to...
2014-01-22
1,064 reads
Easy Backup History Review Script
I often use these scripts to check on the backups of all databases in an unfamiliar SQL Server instance, regardless...
2014-01-22
569 reads
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the...
2014-01-21
16 reads
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...
2014-01-21
855 reads
Win a Free Conference Pass to SQL Server Live in Las Vegas
Taking responsibility for your professional development and making it a priority is essential to being a successful Data Professional. It’s...
2014-01-21
981 reads
Power BI for Office 365 pricing announced
Pricing for Power BI for Office 365 has been announced (see pricing).
It’s all very confusing to me but Melissa Coates does a...
2014-01-21
774 reads
Three Hundred!
Just announced on Friday, SQLSaturday #300 will be held in Kansas City, MO, on September 13, 2014 . Everything about that...
2014-01-21
487 reads
Using Outlook.com
I looked at Outlook.com when it launched and recently revisited. I connected a couple of my personal email accounts to...
2014-01-21
542 reads
Thaw, Rinse, Repeat – #SQLPlunge
Three years ago in March of 2011, on a whim, I jumped into a hole in a frozen lake into...
2014-01-21
608 reads
Moving WordPress to Windows Azure
For the past year or so I’ve hosted this blog at Godaddy using their web hosting service. It took a...
2014-01-24 (first published: 2014-01-21)
1,612 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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