A basic tutorial that examines how Profiler can be used in SQL Server 2005 to monitor your SQL Server instance. MVP Brian Knight shows how to create a trace and the various options you have for monitoring events.
2008-09-02
5,589 reads
Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.
2008-08-28
4,912 reads
MVP Brian Knight walks through the scripting capabilities of Management Studio to show how the code for table creation and the various dependent objects. Brian looks at the options available with scripting and what the implication of choosing them will be.
2008-08-26
2,399 reads
This video covers lift charts, an advanced data mining feature in SQL Server 2008. MVP Brian Knight walks through a data mining example that tests a model with a lift chart.
2008-08-21
2,140 reads
This video examines a new feature in SQL Server 2005: the copy only backup. MVP Steve Jones covers the implications of using this feature and how it can help you avoid broken backup chains.
2008-08-19
2,628 reads
One very handy technique for dealing with the need to copy or move a database involves detaching the database from your instance. MVP Brian Knight shows how easy this can be to perform on your server.
2008-08-14
4,590 reads
Learn how you can add a new database to your instance if you receive the MDF and LDF files from another source. MVP Brian Knight covers this very useful technique that is used for moving databases to new instances, servers, or even recovering from an disaster.
2008-08-12
3,223 reads
Excel is a wonderful tool for examining the data in your SSAS cubes. MVP Brian Knight shows how you can access the data in Analysis Services or a SQL Server database from Excel 2007.
2008-08-07
5,633 reads
This video covers the basics of creating a view in SQL Server. Views allow you to treat a query as a table and simplify your query writing. This view covers the Query Designer in Management Studio.
2008-07-31
5,756 reads
MVP Brian Knight covers the basics of creating stored procedures in SQL Server. Stored Procedures are ways of encapsulating a section of code inside of a function, and this video shows how you to convert your queries to stored procedures.
2008-07-29
11,316 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers