Getting Started With Python For Data Exploration
Intro To get started with running python queries with SQL Server is actually pretty easy. I waited far too long to tackle this, thinking it was much harder than...
2019-11-19
23 reads
Intro To get started with running python queries with SQL Server is actually pretty easy. I waited far too long to tackle this, thinking it was much harder than...
2019-11-19
23 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-19
26 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-19
65 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-19
33 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-27 (first published: 2019-11-19)
1,215 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-11-19
26 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-11-27 (first published: 2019-11-19)
2,441 reads
Today was working on SQL Server cursor standard cursor deification would be like this: sqlcursor from (Azure Data Studio) ———————————————————————————————————————– — Declare a cursor for a Table or a View ‘TableOrViewName’ in schema ‘dbo’ DECLARE @ColumnName1 NVARCHAR(50), @ColumnName2 NVARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT name FROM dbo.TableOrViewName OPEN db_cursor FETCH NEXT FROM db_cursor INTO @ColumnName1, @ColumnName2 WHILE @@FETCH_STATUS = 0...
2019-11-19
360 reads
Recently I have had to troubleshoot quite a bit of SQL login issues and often times the issue was with the users active directory user account.I was aware the...
2019-11-18
1,177 reads
If your organization uses a password policy (there are very good odds these days that it does) and, especially stricter password requirement for administrative users, your might have experienced...
2019-11-26 (first published: 2019-11-18)
1,056 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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