Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy
Learn how you can configure clean and size management for your SSIS catalog database.
2019-05-23
8,609 reads
ozkary
- Interests: big data, data science, cloud data platform
- Blog: ozkary.com
- Skills: Data Platform
- Website: http://ozkary.com
- LinkedIn: https://www.linkedin.com/in/oscardgarcia/
Map IP Address to a Geographical Location
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
53,475 reads
Automate the Publishing of Data Changes into DML Scripts
For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.
2009-11-02
3,349 reads
How to Get the Scripts for SQL Server Objects
Using VB Script allows one to script out all the Sql Server objects in independent file.
2009-03-25
9,930 reads
Blogs
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up
By SQLBalls
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...
Forums
Login failures while connecting from Linux to SQL on windows
Hi all, The app server is running on Linux. SQL server is running on...
Being Responsible for Data
Comments posted to this topic are about the item Being Responsible for Data
Contained Availability Groups
Comments posted to this topic are about the item Contained Availability Groups
Ask SSC