AWS EC2 Linux AMI with pyodbc
AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do...
2018-01-23
72 reads
AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do...
2018-01-23
72 reads
2017-12-01
137 reads
If you are headed to Seattle for the PASS Summit, not only are you in for a week of intense...
2017-10-30
329 reads
Pacific North West, 4000 attendees, training, trends and worldwide industry experts. In a nut shell, the world’s largest conference for...
2017-10-18
156 reads
I’m incredibly excited to be a part of SQL Saturday Denver 673 both as a speaker and co-organizer. I will...
2017-09-11
284 reads
My First Presentation was on Database Security. Those slides are still available for nostalgia sake 66 to 673 in N...
2017-08-17
155 reads
Data Science in DTC Tomorrow - Tuesday June 13, 2017 to be precise – is the initial meeting of a new meetup...
2017-06-12
157 reads
This is part 3 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-16
170 reads
This is part 2 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-09
170 reads
Ensuring and maintaining team productivity practices is important for any organization, especially a small and growing team. The biggest part...
2017-02-07
430 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;