Powershell Day 27
Day 27 Inventory As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as:...
2011-04-27
526 reads
Vinay Thakur
Powershell Day 26
Day 26 Generate script Generate script for sql server objects is very simple, there are different ways we can generate...
2011-04-26
667 reads
Powershell Day 25
Day 25 RMO I have observed that no body has written anything about RMO. And replications is one of my...
2011-04-25
385 reads
Powershell Day 24
Day 24 Performance Monitor Sql Performance: ? performance counters sys.dm_os_performance_counters ? Top ten queries from sys.dm_exec_query_stats and sys.dm_exec_sql_text ? Processor: sys.dm_os_schedulers ?Memory : sys.dm_os_memory_clerks...
2011-04-24
881 reads
Powershell Day 23
Day 23 SMO programming Part 4 AS we can work with Server, Database, Table, Column. You can get the similar...
2011-04-22
365 reads
Powershell Day 22
Day 22 SMO programming Part 3 In earlier blog we have discussed about server and database classes, using table clase...
2011-04-22
506 reads
Powershell Day 21
Day 21 SMO programming Part 2 Continue with my earlier blog where I discussed about the information about SMO. Today...
2011-04-21
493 reads
Powershell Day 20
Day 20 Introduction to SMO >>SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server...
2011-04-20
419 reads
Powershell Day 19
Day 19 Sql Server with .Net Using .Net programming is we can connect to sql server, its similar with any...
2011-04-19
543 reads
Powershell Day 18
Day 18 PSSnapin Powershell works with cmdlets, and cmdlets are commands from snapins. Means spanin contains group of commands. so...
2011-04-18
812 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers