Free SQL Server Goodies


Michael K. Campbell has shared some useful SQL Server goodies that are available online, in his article in DevProConnections. I picked the ones I liked -

* Scripts - TechNet's Script Repository has a vast repository of scripts provided by Microsoft and by its users/customers that you can adapt for your own requirements.

* Books - Red Gate Software which sells some great developer tools also publishes books. Some of them are available for free download in PDF format -
  • SQL Server Stumpers Vol.5 
  • Inside the SQL Server Query Optimizer 
  • SQL Server Execution Plans 
  • Mastering SQL Server Profiler
  • SQL Server Statistics 
  • The Red Gate Guide to SQL Server Team-based Development 
  • Defensive Database Programming
  • Confessions of an IT Manager
  • SQL Server Tacklebox 
  • How to Become an Exceptional DBA
  • The Art of XSD 
  • SQL Server Hardware
  • The SysAdmin Handbook - The Best of Simple Talk 
  • Brad's Sure Guide to SQL Server Maintenance Plans 
  • Exchange 2010 - A Practical Approach 
  • Don't Just Roll the Dice
  • Protecting SQL Server Data
  • Book of Red Gate (about Red Gate, not SQL Server) 
* Videos
Related:
Free SQL Server Videos
HOW TO try Windows Azure & SQL Azure for free (without any credit card)

Comments

Post a Comment

Popular posts from this blog

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Image
The Maven Analytics course on " Data Prep & Exploratory Data Analysis " by Alice Zhao is a beginner-friendly introduction to machine learning with Python. It covers the key steps of the data science workflow, including: Gathering Data Scoping a Project Modeling Data Sharing Insights Cleaning Data Exploring Data Modeling Data  Sharing Insights The presentation deck which is available as a download crisply summarizes the essential details and is a great reference to keep going back to. The course is well-suited for aspiring data scientists looking to get hands-on experience with the data prep and EDA stages of the machine learning workflow using Python and Jupyter Notebook. 
Read more

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

Image
In the Maven Crash Course " Learn Power Query, Power Pivot & DAX in 15 Minutes ", Chris Dutton walks through a hypothetical business case while showcasing the power of modern Excel tools like Power Query, Power Pivot and DAX. Power Query is used to extract, transform, and load data from external sources like SQL databases, PDF and CSV files. A relational model is created to join the tables without writing a single formula. Exploratory analysis is done using Power Pivot and Data Analysis Expressions (DAX). Data Analysis Expressions is the language that we can use to define new calculated columns and measures to enhance our Data Model instead of the traditional cell formulas that we'd typically use if our data was stored in worksheets. Pivot Charts and slicers are used to design a simple interactive report that the sales managers can use to analyze revenue trends and product performance.
Read more

Workshop Highlights - Build AI Apps using Google AI Studio & Gemini AI

Image
Harsh Dattani's ~60-minute walkthrough of Google AI Studio during the workshop " Build AI Apps using Google AI Studio & Gemini AI " provides all the essentials you need to get started. Topics covered: Google AI Studio -browser-based IDE for prototyping with generative models Gemini AI - lets you access the latest generative models from Google API key - prerequisite for building apps with Gemini AI Prompt engineering Prompt Gallery  - examples of what's possible with Gemini models Fine tuning  - provides a mechanism for curating output when you have a small dataset of input/output examples System Instructions - for developers to manage prompts  idx.dev - cloud-based IDE for building Web, Android apps Focus of the workshop is on the inner loop of software development Google AI Studio provides several interfaces for prompts that are designed for different use cases Google AI Studio is a good starting point for beginners and small-scale projects, while Vertex AI St
Read more