Sacramento SQL Server User Group

Login to Subscribe

Disclaimer

All script, code and documentation is presented "as is", please make sure you understand its functionality before implementation.  The Sacramento SQL Server User Group takes no responsibility for any issues.

Scripts, Files and Downloads

 TitleDescriptionCreated DateSize 
Massive Data Ingestion in Power BI"Massive Data Ingestion in Power BI", Armando Lacerda, May 2, 20185/3/20183.58 MBDownload
Dynamically Create & Maintain Partitions in Large Tables"Dynamically Create & Maintain Partitions in Large Tables", Saru Radhakrishnan, April 4, 20184/5/201824.11 KBDownload
Stored Procedure Optimization Techniques"Stored Procedure Optimization Techniques", Kimberly L. Tripp, December 6, 201712/11/20173.07 MBDownload
Answering the Question, "What Happened?" with Query Store"Answering the Question, 'What Happened?' with Query Store", Erin Stellato, September 6, 20179/12/20171.78 MBDownload
Stored Procedure Optimization Techniques"Stored Procedure Optimization Techniques", Kimberly L. Tripp, March 2, 20163/2/20162.77 MBDownload
Configuring a Test Environment"Configuring a Test Environment", Glenn Burnett, February 3, 20162/4/20161.19 MBDownload
Performance Troubleshooting Using Wait Statistics"Performance Troubleshooting Using Wait Statistics", Paul Randal, June 3, 20157/8/20153.16 MBDownload
Making the Leap from Profiler to Extended Events"Making the Leap from Profiler to Extended Events", Erin Stellato, April 1, 20157/8/20151.79 MBDownload
7 Free SQL Tools that Every DBA Needs to Know"7 Free SQL Tools that Every DBA Needs to Know", Mitch Bottel, February 4, 20152/6/2015513.66 KBDownload
Become a Microsoft Certified Professional of SQL Server"Become a Microsoft Certified Professional of SQL Server", Frank Qin, February 4, 20152/6/2015751.42 KBDownload
Tuning Performance of Virtualized SQL Server Workloads on VMWare vSphere"Tuning Performance of Virtualized SQL Server Workloads on VMWare vSphere", Deji Akomolafe, February 4, 20152/6/20153.05 MBDownload
Excel Pivot Table Best Practices for Loading Data Directly from SQL Server"Excel Pivot Table Best Practices for Loading Data Directly from SQL Server", Tom Keller, February 4, 20152/6/2015UnknownDownload
SSIS, Excel, and You: Office Automation with SSIS for Financial AnalysisScripts, slides, docs, code and instructions from Christian Chanco's January, 2015 presentation.1/20/2015308.75 KBDownload
SQL Server Encryption 3 WaysSlide deck from Dan Hess's April, 2013 presentation6/15/2013330.89 KBDownload
SQL 2012 AlwaysOnPowerPoint slide deck from Dilip Nayak's October, 2012 presentation.5/30/2013105.76 KBDownload
PowerView presentationPresentation outlining Microsoft SQL Server 2012 PowerView and PowerPivot for Excel and Sharepoint. Created and contributed by William Brown of Microsoft, May 2, 2012.5/3/20120.36 KBDownload
Database mirroring w/ Transparent Data EncryptionSlides and scripts from presentation on database mirroring with transparent data encryption. Contributed by Dan Hess of CSU Sacramento on April 4th, 2012.4/18/2012175.20 KBDownload
Analysis Services Tabular Project BI Semantic ModelDocumentation for developing an Analysis Services Tabular Project BI Semantic Model. Created by Peter Myers of Solid Q, contributed on August 16, 2011.11/2/20110.39 KBDownload
T-SQL Maintenance Plan Replacement ScriptsCollection of T-SQL scripts to replace SQL Server maintenance plans. Created by Brandon Forest, contributed on September 22, 2010.11/2/201115.83 KBDownload
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids