Eli Leiba

Eli
Leiba

Eli Leiba works at Israel Electric Company as a senior application DBA in Oracle and Microsoft SQL Server. He has a bachelor of science degree in computer science and 21 years of experience working with databases. Eli holds certifications from Microsoft and Brainbench in Oracle and SQL Server database administration and implementation. He also teaches SQL Server DBA and development courses at Microsoft CTEC and serves as a senior database consultant for several Israeli start-up companies.  

Articles
Optimize the Size of Your Indexed Integer Columns
Together, the suggestIntType and scanIntIndex procedures search for indexed integer columns in a database and determine whether the optimal data type is used for those columns.
Stored Procedures Work in Concert to Import and Export Data
Here’s a simple yet generic solution for exporting or importing data. This solution consists of two stored procedures: BCPObject and ExpOrImpDB.
Don’t Let Resource-Intensive Sessions Consume All Your Resources and Time
The getMaxResourceConsumeSessions stored procedure lets you quickly identify the sessions that are consuming most of a SQL Server machine's resources.
John Savill's PowerShell Master Class

Join John Savill for 9 hours of comprehensive PowerShell training. This course will start from the ground up, walking through the basics of PowerShell, how to create basic scripts, and building toward creating custom modules to achieve amazing results in your environment, in non-Microsoft environments, and in Azure.

Invest a few hours each week and become the #1 PowerShell expert in your organization.

Sessions meet Thursdays, March 5th through March 19th

Topics covered will include:

  • Remote management with PowerShell
  • Connecting commands and mastering objects
  • Creating PowerShell scripts and best practices to aid in code reuse
  • Parsing data and working with objects
  • Desired State Configuration
  • Building PowerShell workflows using Orchestrator SMA and Azure Automation
  • PLUS new capabilities in PowerShell 4.0 and 5.0

 

Windows Forums

The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.

Sponsored Introduction Continue on to (or wait seconds) ×